How to add rows using ADF DataFlow

Abhijit Bhadra 91

Hello All,

I have tables of Azure SQL DB which already transformed into JSON structure using ADF Dataflow.
Now rows need to be added, Alter Row will not work as my sink pointed to Blob storage container.
Below is the example of Data preview of sink post JSON transformation from a table from Azure SQL DB.

Column1 Column2 Column3
22C 189 True
23D 190 False

in this i need to add rows like

Column1 Column2 Column3
40N 223 True
41O 224 True

Please suggest any way to achieve this.

ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2022-05-12T15:50:09.14+00:00
Hi @Abhijit Bhadra ,

Thank you for posting query in Microsoft Q&A Platform. Sorry you query is unclear. Kindly help with clarifications on below ask to help better.

You mentioned you transformed data to JSON structure and how I don't see data as JSON in query. Kindly elaborate more on this?

What you mean when you say you want to add rows? How you are computing or generating new rows? Is it something which you are reading from any source? If yes, then kindly consider using Union Transformation to combine rows.

Alter row transformation actually helps to alter rows in Sink systems. Could you please help me to understand why alter row transformation is getting mentioned here?

Looking forward to details on above asks to help better. Thank you.
Abhijit Bhadra 91 Reputation points

2022-05-13T12:44:54.927+00:00

Hello Maheer,

Issue has been solved by my side.
Thanks for concern.
ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2022-05-19T15:36:04.357+00:00

Hi @Abhijit Bhadra - Very happy to know that issue resolved. Please feel free to share your resolution details here to help community as well. Thank you.