Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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