Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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