Forum Discussion
Create New Column and Extract Values from another column containing list of tags
That looks like JSON to me.
Highlight the column and do Transform / Parse / JSON and (if I'm right!) you should get a column for each data-part. In the case of your example, three columns, one each for Cost Center, Application and Environment.
GazzerThanks for your reply! So I tried that and in the original Tags column now the values are either Error or Record.
Here is the Error Message: DataFormat.Error: We reached the end of the buffer.
Where would I find the new columns if it did work for the others?
Thank you!
Sorry, I did not think that through.
First duplicate the original column and then do the Parse JSON function on the duplicate.
This should create a column populated with "Record" (not sure about the error part of this, but one step at a time) in it. You need to click the little button in the header, to the right of the name (like two little arrows).
This will let you choose the fields to extract from the tags.
If you could post a couple of the tags for those that fail, maybe we can work out why they error (assuming there is nothing sensitive in the data, of course).
