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
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.