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.
SOLVED

Append Field by joining data from same source

timewaste
8 - Asteroid

Hi Peers,

 

Newbie here. How can I accomplish this? The data in column E should be same as data in column A. TIA!

 

Source Sheet (for both sources - columns A,B,C,D and E): 

 

A BCD
1b1c1d1
2b2c2d2
3b3c3d3

 

Target Sheet:

 

A BCDE
1b1c1d11
2b2c2d22
3b3c3d33

 

Workflow:

 

alteryx issue.png

 

3 REPLIES 3
JoshKushner
12 - Quasar

A join should get you what you need

 

Flow:

 Flow.PNG 

 

Results:

results.PNG

 

Join:

join.PNG

JoshKushner
12 - Quasar

Or if you're saying how do you create column E from a single input that has columns A-D then use the formula tool to create a new column equivalent to A:

 

Flow:

flow 2.PNG

 

Results:

resutls2.PNG

 

Formula:

formula.PNG

timewaste
8 - Asteroid

Thanks once again!

Labels
Top Solution Authors