Forum Discussion

RickFerreira220's avatar
RickFerreira220
Copper Contributor
Nov 17, 2021

Add rows between values on two columns. Azure Data Factory

Hi All,

I have a table like this:

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

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

  • Swapneel91's avatar
    Swapneel91
    Copper Contributor

    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

Resources