I am trying to read data from SAP using read tool, the data has more than 100 columns and last few columns are moving to the next line. I can't convert 2 rows as a header at the raw preview stage. If anyone has solution for this please let me know.
As shown in the screenshot here, Row no. 2, 3 are column names and Row no. 5, 6 are the corresponding data I want to see each of them in a single line.
Thanks!
You could use a record ID tool, and then a filter tool to separate out all rows that can be divided by two as an example, and then build out the rest of the flow from there