In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

How can I group two different structure data together?

phoebe_90
8 - Asteroid

structure A:1 column*3 rows

a
b
c

structure B: 5 columns * 5 rows

     
     
     
     
     

Which join tool can I use to combine these two sets of data up and down?

5 REPLIES 5
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

If I understand correctly, you can use Union Tool with "Auto Config by Position" option.

 

Workflow

1275107_Workflow.png

 

Output

1275107_Output.png

 

phoebe_90
8 - Asteroid

But my structure B have Column label, Once I use this tool, the column label will on the top.

I want make the the column label on the fourth line.

For example,

structure B:

Company vendoraddressaccountcost center
12345
12345
12345
12345
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

You can read data with Input Data Tool with "First Row Contains Data" as True.

 

Output

1275107_Output2.png

phoebe_90
8 - Asteroid

But the two group data are my workflow result, not input data, how can I let the "First Row Contains Data"?

Yoshiro_Fujimori
15 - Aurora
15 - Aurora

Well, you can extract the field information with Basic Data Profile tool. I hope there is no other news...

1271507_Workflow2.png

Labels
Top Solution Authors