Forum Discussion

AWGames's avatar
AWGames
Regular Visitor
6 years ago
Solved

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

  • AWGames's avatar
    AWGames
    Regular Visitor
    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.