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.
595 | 595 | 595 | 587 | 587 | 587 | 238 | 238 | 238 | 238 | 238 | 238 | 312 | 312 | 312 | |||||
Group | brand_code | num | SKU | price | quantity | Stock_wh | Cost price | quantity | Stock_wh | Cost price | quantity | Stock_wh | Cost price | Sold qty Store | Sold Value Store | Cost of Sales Store | quantity | Stock_wh | Cost price |
P01612 | P0 | 201 | P020007101 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
P0315 | P0 | 201 | P020054351 | 35 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.2632 | 0 | 0 | 0 | 0 | 0 | 7.2012 |
P01912 | P0 | 204 | P020086184 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
P0802 | P0 | 204 | P020169495 | 39 | 0 | 0 | 44.29962 | 0 | 0 | 44.29874 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
P0802 | P0 | 204 | P020169497 | 75 | 0 | 0 | 43.79502 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
P0802 | P0 | 204 | P020169502 | 100 | 0 | 0 | 44.93691 | 0 | 0 | 44.93691 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
P01912 | P0 | 204 | P020385905 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
P0315 | P0 | 201 | P020546138 | 35 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6.37058 | 0 | 0 | 0 | 0 | 0 | 0 |
Solved! Go to Solution.
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.
Hi @abdoul,
I would recommend reading in your Excel sheet as raw data:
Then use the Transform & Join tools to break it apart and put it back together in your desired format:
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
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.