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