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

SPLIT DATA USING A SPECIFIC COLUMN AND ADD COLUMN NAMES

Shahas
8 - Asteroid

Hi All,

 

I have a situation where in I have to group data by country and after each country is over, a separate header has to be given when a new country name begins.

 

for eg : 

 

IDNAMECOUNTRY
12ABAUS
35CDIND
64LEAUS
78OIIND
95FGSUI
21LFSUI
65POUK
17LQUK

 

This data has to look like : 

 

IDNAMECOUNTRY
12ABAUS
64LEAUS
IDNAMECOUNTRY
35CDIND
78OIIND
IDNAMECOUNTRY
95FGSUI
21LFSUI
IDNAMECOUNTRY
65POUK
17LQUK

 

Hope its clear.

 

Thanks in advance

10 REPLIES 10
Shahas
8 - Asteroid

@ArtApa This works. Thank u so much

 

Thanks to @ShankerV @binuacs for your assistance as well. Really appreciated

Labels
Top Solution Authors