Help Required Please...

[samvile18]

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: 

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

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??

[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.