I have sample data which looks like this
The flow that I would like to achieve is, first I would like to dump the “Number” data in table1 , next I want to get the data number within the data array and put it in a SQL script, so that I can insert it in the DB. I have already tried the json splitter on the “data” array which does the job but I would like to avoid the splitter.
we have 1 document as input but when we split the lines, number of output would be more than 1. If we use a SQL script to achieve the same functionality , we can achieve 1 input 1 output.