Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.