Forum Discussion
Create New Column and Extract Values from another column containing list of tags
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).
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?
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.