Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Data transformation - Data rows above headers into column

Highlighted
7 - Meteor

Hi community,

Actually i am facing a data transformation issue with Alteryx. 

I have a dataset with a row data that is above the header rows. 

 

My purpose is to transform the first rows the header which should be in a column name STORE_CODE.

I tried some solutions like transposing those columns with extra rows but never find a proper solution.

Can you please help, i will attach a sample of data?Thank you. 

 

     595595595587587587238238238238238238312312312
Groupbrand_codenumSKUpricequantityStock_whCost pricequantityStock_whCost pricequantityStock_whCost priceSold qty StoreSold Value StoreCost of Sales StorequantityStock_whCost price
P01612P0201P020007101000000000000000
P0315P0201P02005435135000000007.2632000007.2012
P01912P0204P02008618420000000000000000
P0802P0204P020169495390044.299620044.29874000000000
P0802P0204P020169497750043.79502000000000000
P0802P0204P0201695021000044.936910044.93691000000000
P01912P0204P020385905000000000000000
P0315P0201P02054613835000000006.37058000000
Highlighted
8 - Asteroid

Hi @abdoul ,

 

Can you provide a sample of the desired output?  I'm not sure if that was in your attached Excel file, but I was unable to open (likely due to firewall on my side).

 

Thank you.

 

 

Highlighted
Alteryx Certified Partner

Hi @abdoul

 

I would recommend reading in your Excel sheet as raw data:

1.1.PNG

 

Then use the Transform & Join tools to break it apart and put it back together in your desired format:

 1.2.PNG

Highlighted
Alteryx
Alteryx

Hey @abdoul , 

 

This is for sure an interesting transformation example. I have given it a shot, please see the attached workflow and let me know if it gets you your desired output. 

 

Best, 

Nick Michels

Highlighted
7 - Meteor

Thanks for your quick reply, @Aaron_Harter  and @NicholasM  lead pretty much to the same result which which solve a big part of my problem. 

 

But now is there a way to go a little bit further and have the result in SKU level the dataset is way larger than the sample that I shared so more than 100 STORECODES ?? I mean by that having only STORECODE for only the existing SKU and avoid the NULL value in the bottom of the result (please see attached image for what i am referring). Let me know if you have an idea.

 

@DQAUDIT  I hope that reply to your question about the result that i am looking for. I will attach as well again the sample for you. 

 

thank you.

Labels