Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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
binu_acs
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

binu_acs
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 @binu_acs 

Divide_Dataset_29042024-A.pngDivide_Dataset_29042024-B.png

Labels
Top Solution Authors