We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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