Forum Discussion
List drilldown
Hi,
I connected to a wikipedia table for a list of official languages for countries, the language column contains values as well as lists and I'm having difficulty extracting the lists.
When I double click the list and then click "To Table" as many guides say to do then the resulting 2 item list replaces all the data from my original table with a 1 column table with 2 rows. I've tried to extract and split the column but each requires a deliminator where the characters can vary and there's no comma or other deliminator that I can see.
I know this is very basic stuff but I can't find a single post that works for extracting this list of values without giving errors and none of the guides or tutorials I've seen on Power BI tutorial cover this.
- Update: I've solved the problem by connecting to a better source that doesn't mix string values and lists and then pruning that down to single languages I needed and merging into the existing data set. However if anyone does know a way to deal with lists merged with string values in columns like this I would appreciate a solution to an inevitable problem.
2 Replies
- AWGamesRegular VisitorUpdate: I've solved the problem by connecting to a better source that doesn't mix string values and lists and then pruning that down to single languages I needed and merging into the existing data set. However if anyone does know a way to deal with lists merged with string values in columns like this I would appreciate a solution to an inevitable problem.
- v-gizhi-msftCommunity Support
Hi,
Please try to convert your list to table by using Table.FromList .
Hope this helps.
Best Regards,
Giotto Zhi