In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to add 2 different datasets one after the other as a block in excel output

saachitalwar
8 - Asteroid

I have datasets in the below forms: (union and append dont seem to be working

 

date
dd/mm/yyyy
dsnjdifghgbwjhbgwrjhgbwrjhtgbwr

 

date
dd/mm/yyyy
dsnjdifghgbwjhbgwrjhgbwrjhtgbwr

 

and I wish to have the form:

 

date   
dd/mm/yyyy   
dsnjdifghgbwjhbgwrjhgbwrjhtgbwr   
    
h1h2h3h4
abcd
efgh4
3 REPLIES 3
binu_acs
21 - Polaris

@saachitalwar it should work with union tool

image.png

saachitalwar
8 - Asteroid

How can I get my datasets in this format

 

f1 f2 f3 f4

d1 d2 d3 d4

 

Gaurav_Dhama_
12 - Quasar

Change Union configuration to "Auto Config by Position" or "Manually Configure Fields"

Labels
Top Solution Authors