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

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

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

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

1271507_Workflow2.png

Labels