Hello, I am new to azure data factory and am having trouble combining multiple groups of rows into one row using a dataflow.
I have a test file that looks something like this
HEADER
ACT1 data1
ACT2 data2
ACT3 data3
ACT1 data4
ACT2 data5
ACT3 data6
FOOTER
Every three rows of data within this file refer to one row within a database. What I am trying to do is concatenate every group of three rows together so I can load it into a database. I would want it to look like:
HEADER
ACT1 data1ACT2 data2ACT3 data3
ACT1 data4ACT2 data5ACT3 data6
FOOTER
What would be the best way to do this?
Thanks





