Alteryx Designer Desktop Discussions

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

Insert data in column, based on data in another column.

JEM
6 - Meteoroid

Hi, I hope some of you may be able to help me with a small problem I have encountered, and haven't found a way to solve so far.

As shown in the picture; 

My data currently looks like the upper example, and I am trying to turn it into the example below.

The accounting system puts the account number into the column as the date. I wish to separate the account number into a new column, as shown.

I have done this in Excel with VLOOKUP, however, as this is a recurring issue, I would prefer a flow in Alteryx.

I hope someone has an idea on how to perform this action, thank you!

Skærmbillede 2022-01-28 095806.png

 

11 REPLIES 11
JEM
6 - Meteoroid

Much appreciated! My life just got a little easier

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @JEM 

Cheers and have a nice day!

Labels