Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to combine different datas in one sheet

Belletmns
8 - Asteroid

Hi All,

 

I want to combine two different data into one sheet. Should look like this:

 

3. On Hold    
EIDEEStartEndRemarks
xxxxxx
xxxxx
xxxxxx
     
4. Intern    
EIDEEStartAllowRemarks
xxxx
xxxx

 

Thanks!

2 REPLIES 2
wdavis
Alteryx
Alteryx

Hi @Belletmns 

 

I have attached a workflow with 2 options of how you can do this.

 

The first is simply stacking them together in a Union to give an output as you have identified below.

 

The second creates logic so that each record has the filename associated with it. This would make it easier to do any processing further down the line with all the data in one tabular format.

 

Let me know if this works for you!

 

Kind Regards,

Will

Belletmns
8 - Asteroid

@wdavis thank you!

Labels