Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Data transformation - Data rows above headers into column

abdoul
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
4 REPLIES 4
DQAUDIT
9 - Comet

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.

 

 

Aaron_Harter
11 - Bolide

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

NicholasM
Alteryx Alumni (Retired)

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

abdoul
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