Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to create buckets based on following values
0-100,'BUCKET1',
100-200,'BUCKET2',
0-200,'BUCKET3'
The third bucket is not displayed.Any solution to display the third bucket as well as the first two ?
There you go:
After intervalmatch, concatenate a fresh fact table and assign 'BUCKET3' as BucketName.
Refer qvw below as reference.
Thanks and regards,
Arthur Fong
Hi,
You can try this if this helps.
Client_Final:
load * inline [
Customer ID,Customer Name,Customer Age,Customer Address
1,Ajay,25,Address1
2,Avi,31,Address2
3,Gauresh,25,Address3
4,Bilal,25,Address4
5,Yogesh,25,Address5
6,Wasim,25,Address6
7,Sanket,20,Address7
8,Ankit,21,Address8
9,Vishal,20,Address9
10,Mack,31,Address10
];
Final:
load
[Customer ID],
[Customer Name],
[Customer Age],
[Customer Address],
if([Customer Age]<25,'0 - 25',
if([Customer Age]>=25 and [Customer Age]<=35,'25 - 35',
if([Customer Age]>=36 and [Customer Age]<=45,'36 - 45'
))) as AgeGroup
Resident Client_Final;
Concatenate(Final)
load
[Customer ID],
[Customer Name],
[Customer Age],
[Customer Address],
if([Customer Age]>0,'All Age') as AgeGroup
Resident Client_Final;
Drop Tables Client_Final;
exit script
There you go:
After intervalmatch, concatenate a fresh fact table and assign 'BUCKET3' as BucketName.
Refer qvw below as reference.
Thanks and regards,
Arthur Fong
Ameya, did Arthur's post and example app do what you needed? If so, be sure to use the Accept as Solution button on his post to let others know and give him credit for the help. That would be the preferred method of doing things from what I know, so hopefully that did the trick. If you still have further questions, shout back.
Regards,
Brett