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
7 - Meteor

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
20 - Arcturus

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

image.png

saachitalwar
7 - Meteor

But this way the headings remains the same as date

binuacs
20 - Arcturus

@saachitalwar updated workflow attached

image.png

Qiu
20 - Arcturus
20 - Arcturus

@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