Forum Discussion

Bepachec's avatar
Bepachec
New Member
8 years ago

Create New Column and Extract Values from another column containing list of tags

Hello :)    I have a column "Tags" where each cell going down the column has a long dictionary of items if you will. An example cell would look like: {"Cost Center": "0000", "Application": "PowerBI...
Need Help
Tips and Tricks
Tutorial Requests
Bepachec's avatar
Bepachec
New Member
8 years ago

Gazzer 

 

Thanks for that! So I did that and it looked like it parsed it accordingly. However, the errors are coming from those that do not have any values in the duplicate column. Is there a way to fix that? 

Gazzer's avatar
Gazzer
Resolver II
8 years ago

I just tried a little experiment and I think it is that the empty fields are not truly empty.

 

Immediately after duplicating the column, insert a new step to Replace Values. Put nothing in the first box and then type null in the second one. No quotes or anything, just the word null in lowercase.

 

I also tried replacing with curly braces {} with nothing between and that worked as well.

  • Bepachec's avatar
    Bepachec
    New Member
    8 years ago

     

    Gazzer

    Thanks for that - It looks like the {} fixed that issue. Now when I click the little icon to add the columns i get a message that says limit of 1000 rows scanned complete. However, the columns I need are not in that list.