Imported table with lists

Hi @powerbideveloper,

You would have to know the source to answer that Q.
.

How you treat them depends on the data they contain and what you need to do with that data…

  • Expanding to new rows will lead to “duplication” of all other fields in that row if there is more than 1 item in that List.
  • Alternatively you could “Extract values” combining them into a single text string (and optionally separating those into new columns (if that makes sense for your data))
  • or aggregate the results into a single value if for example you have a numerical field in that list
  • However if you don’t need the data at all, don’t bring it in or just delete that column

You’ll have to make sense of that…

1 Like