Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

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

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

JEM
Météoroïde

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 RÉPONSES 11
JEM
Météoroïde

Much appreciated! My life just got a little easier

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @JEM 

Cheers and have a nice day!

Étiquettes