Return a specific value from onto a different column

[Anonymous]

Hello Experts,

I have a dataset where the rows refer to specific unique identifier and column refers multiple unique tag id's which has different meaning for each tag. They are related to a specific User. sample data;

I would like to pick a specific tag from tag_ids column and return it a new column. Specific tags are as follows,

5543254

5543252

5543250

I tried splitting columns, but its not working out wel for me. becuase specific tags are distributed differently in every rows. 

Would appreciate if you could help me with this.

thanks

[AlB]

Hi @Anonymous 

Please provide the sample data in text-tabular format instead of in a screen pic and show the expected result, explaining the logic to get there. It's unclear now

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[amitchandak]

@Anonymous , I think you can split the column into the rows - https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

[Anonymous]

Hi @amitchandak ,

thank you for ur reply. I tried that option. But the desired output/returned values are storing into different columns with this technique. As per my example, all "specific ids" are located at the end of the string. Whereas, in my dataset they are located differently in each row. I would like to have them stored into one column. Later it will me to use look up function to get their name from different table against each tag id. I just want to hold them into one column.

[amitchandak]

@Anonymous , end of the string is possible with split using the right most delimiter. For others, you might put some specific logic. Can share How you come up with those three rows in first post