Add rows between values on two columns. Azure Data Factory

Copper Contributor

Hi All,

I have a table like this:

RickFerreira220_0-1637162246034.png

I need to add rows with the number between low and high, like this:

RickFerreira220_1-1637162289350.png

I only can use the data flow on Azure Data Factory.
Is there possible to built that transformation using only task on Data flow?

Thanks

1 Reply

@RickFerreira220 Did you resolve this scenario?

I am having a similar scenario now, I need to split the range 1..10 -> 1,2,3,4..,10 alongwith primarykey.

 

Thanks,

Swapneel91