Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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