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

Divide one dataset into two tables with different headings

saachitalwar
8 - Asteroid

I have data in the form:

 

date   
dd/mm/yyyy  
    
h1h2h3h4
abcd
efgh

 

I need to make 2 different tables like below so I can perform some operations on the second table then merge both back

 

date
dd/mm/yyyy

and 

h1h2h3h4
abcd
efg

h

4 REPLIES 4
binuacs
21 - Polaris

@saachitalwar use the sample tool to select the records you want 

image.png

saachitalwar
8 - Asteroid

But this way the headings remains the same as date

binuacs
21 - Polaris

@saachitalwar updated workflow attached

image.png

Qiu
21 - Polaris
21 - Polaris

@saachitalwar 
We can use the Dynamic Rename tool to configure the Column Names based on flow of @binuacs 

Divide_Dataset_29042024-A.pngDivide_Dataset_29042024-B.png

Labels
Top Solution Authors