Forum Discussion

dinkar's avatar
dinkar
New Contributor
2 years ago

Need to know all the columns in input pipeline using expression in mapper snap

I Want to know the all the input columns in the pipepline  using expression in mapper snap. I used $.keys() function in mapper snap its gives information for all the rows(if we have 1lakh records for...
vish's avatar
vish
Former Employee
7 years ago
Copy LinkReport

Hello Kiran, Could you share the output of the XML formatter as well as a screenshot of the mapper? Most likely, you’d need to use the JSON Splitter snap after to ‘flatten’ the data to fit into a relational database. Thanks!

  • arvindnsn's avatar
    arvindnsn
    Contributor
    7 years ago
    Copy LinkReport

    The expected output is typical records to load into Oracle DB