Load Excel data into SQL table by pivoting specified set based on set of columns

aparanjith1

Hi,

I want to load the date of excel sheet into a SQL table, and I have to load the same set of data into the table based on the scenario value of the column. For example see the image below

,

My table will have 7 columns like Asset_Class, Asset_product, Buy_sell, Put_call, ccy, Index and Scenario.

So, I need to load the data from column A to F and scenario "BHC severely Adverse" as 1 set if data. Similarly, column A to F and scenario "Severe USD crisis" as set 2; and column A to F and scenario "JPM Severely Adverse" as 3rd set of data.

Is there a way we can do this in alteryx in one shot?

Much appreciated, Thanks!

Test.PNG

aparanjith1

This worked just by using a simple pivot tool and selecting the desired columns from them.