topic Re: Help Required Please... in App Development

Help Required Please...

samvile18 — Wed, 22 Dec 2021 15:42:54 GMT

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

Re: Help Required Please...

rubenmarin — Sun, 18 Jul 2021 08:00:59 GMT

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.