Pivoting based on Row Number in Azure Data Factory - Mapping Data Flow

Question

I am new to Azure and am trying to see if the below result is achievable with data factory / mapping data flow without Databricks.

I have my csv file with this sample data :

I have following data in my table :

My expected data/ result:

Which transformations would be helpful to achieve this?

Thanks.

Answer 1

Now, you have the RowNumber column, you can use pivot activity to do row-column pivoting.
I used your sample data to made a test as follows:

1. My Projection tab is like this:
2. My DataPreview is like this:
3. In the Pivot1 activity, we select Table_Name and Row_Number columns to group by. If you don't want Table_Name column, you can delete it here.
4. At Pivote key tab, we select Col_Name column.
5. At Pivoted columns, we must select a agrregate function to aggregate the Value column, here I use max().
6. The result shows:

Please correct me if I understand you wrong in the answer.

---

update:

1. The data source like this:
2. The result shows as you saied, ADF sorts the column alphabetically.It seems no way to customize sorting:
3. But when we done the sink activity, it will auto mapping into your sql result table.