Multilevel data in different columns

Hello,

I have a file with eight columns (A to H), each one representing the description of the code in column I. Is there a way to have one column with the respective material description?

I am not sure if I was clear but below you can see an example:

- Code 45 has the description in column A

- Code 45,200 to 4511 has the description in column B

- Code 451116 has the description in column C

I am looking for a solution in Alteryx to have two columns: one for the material code and another for the description.

Did anybody work on this before? Would you mind sharing your thoughts?

Thank you.

Madi

Developer

Output

Tips and Tricks

Best Practices

Accepted answers

acarter881

Hello @MadiNissi. Here's how to get the exact output you are looking for.

move data.yxmd

binu_acs

@MadiNissi Similar to other solutions

Multi_Data_0111.yxmd

All comments

CarliE

@MadiNissi

Can you send a sample dummy data excel file? and the expected outcome?

MadiNissi

@CarliE - Sure, please find attached the dummy data.

Dummy-Data.xlsx

acarter881

Hello @MadiNissi. Here's how to get the exact output you are looking for.

move data.yxmd

binu_acs

@MadiNissi Similar to other solutions

Multi_Data_0111.yxmd

MadiNissi

Hi - It worked! Thank you for sharing the solution! 😉

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703