In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

data reformatting

Yoba1Two
5 - Atom

Hello Alteryx community, 

 

I'm pretty new to Alteryx and so far it's amazing.. just I have one thing that I couldn't figure how to do it (used to do it Excel but it takes time and a lot of manual work..) and the reason I started using Alteryx was to automate it.. 

 

so I have this dataset with duplicates in MATNR field. each row is unique 

There are from 1 to 6 occurrences for each MATNR (1 min and 6 max)

Yoba1Two_1-1638894744406.png

 

The idea is to transform the data above into something like this

So each column from the initial dataset will be repeated 6 times except for MATNR which is the key 

for example for MEINH I'll have MEINH_1, MEINH_2...MEINH6 and for UMREZ I'll have UMREZ_1, UMREZ_2...UMREZ_6 and so on 

Yoba1Two_2-1638894915534.png

 

So the end result for the first MATNR for ex 1002324 should look like this 

Yoba1Two_4-1638895389521.png

 

Many thanks indeed for your help 🙂 

 

 

 

 

 

 

5 REPLIES 5
TheOC
15 - Aurora
15 - Aurora

hey @Yoba1Two 

can you please attach your input dataset?

If not i can try to get it working with a quick example.

Cheers,
TheOC

Cheers,
TheOC
Connect with me:
LinkedIn Bulien
Yoba1Two
5 - Atom

Yes, here is a sample from my dataset 

Thanks you for the quick answer 

binuacs
21 - Polaris
Spoiler
binuacs_0-1638918357710.png

 

Yoba1Two
5 - Atom

Hello @binuacs, 

 

Thank you for your help 

 

I tested it and not sure why I'm getting it like this.. did you change anything in the sample dataset? 

 

Yoba1Two_0-1638955013299.png

and it goes MEINH_1, MEINH_2....MEINH_16 while it should only be 6 for each.. 

Any idea on how to fix this?

 

binuacs
21 - Polaris

@Yoba1Two  the files are writing up to 5 ie MEINH_1, MEINH_2....MEINH_5. Not sure why you are getting different result> I am attaching the workflow again

Spoiler
binuacs_0-1638960185006.png

 

Spoiler
binuacs_1-1638961106600.png

 

Labels
Top Solution Authors