Forum Discussion
Help with extracting a JSON
Hi All, So we have an applications portal where people can choose various answers and submit an application for funding. I have managed to (mostly) successfully extract the "responses" JSON i...
Success!
Instead of replacing errors with 0, I removed them instead. I can now extract the list to individual rows and perform my calculations from there.
I'm learning!
amitchandak no, the column doesn't expand or have the expansion icons. I suspect it's because the "List" is of different lengths per record (could be anywhere from 0 to 6 list entries).
Success!
Instead of replacing errors with 0, I removed them instead. I can now extract the list to individual rows and perform my calculations from there.
I'm learning!
Hi Anonymous ,
Glad that you have resolved it. You could accept your answer as solution. More people who have the same requirement will benefit from this thread.
