Splitting multiple columns by delimeter

[Anonymous]

Hi there

So I have a column in my dataset called 'Tags' which contains multiple values. I can split by delimiter to create multiple tag columns which has the tag name and value separated by a colon e.g. Environment:Dev

There could be any number of tags in the dataset so the number of Tag columns, once split, could change each time the report refreshes. 

Is there anyway I can split all these columns into two new columns of tag name and tag value without splitting each column by delimiter?

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

You need to make 'List' column selected, click 'Split Column'=>'By Delimiter', set as below.

Then you may make 'List' column selected, click 'Split Column'=>'By Delimiter', set as below.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwegener]

Thanks Allan, that's what I meant.

[mwegener]

Hi @Anonymous ,

In the first step, split the column into rows.

https://community.powerbi.com/t5/Desktop/Splitting-the-column-values-with-comma-and-storing-them-as-rows/td-p/347562