Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
samvile18
Creator III
Creator III

Help Required Please...

Hi all,

I have a query that I can't seem to figure out and it's killing me!! I have the following data table: AgeBandDataCut.jpg

I need to try and get it into the following format and I honestly can't seem to figure it out:

AgeBandDataCut1.jpg

I essentially need to show how the member movements in the buckets as they get older. 

Can anyone out there help me at all please??

Labels (1)
1 Reply
rubenmarin

Hi, I think you ca split the load in pairs Age band using a bucle:

Data:
LOAD
  MemberID,
  Age,
  AgeBand as AgeBand
From...;

// Add other pairs
FOR i=1 to 10
Concatenate (Data)
LOAD
  MemberID,
  Age$(i),
  AgeBand$(i) as AgeBand
From ...;

After that you can create the table with AgeBand and dimension and Count(age), Count(Age1)... as expressions

Or using a Group by AgeBand if you want it on script.