Age Buckets.qvw

    Hi,

    Please find the details to create Age Bucket.

     

    Customer_Age:

     

     

    LOAD *,

    if(Age >=0 and Age<=19,Dual('0-19Yrs',10),

    if(Age>=20 and Age<=25,Dual('20-25Yrs',20),

    if(Age>=26 and Age<=35,Dual('26-35Yrs',30),

    if(Age>=36 and Age<=45,Dual('36-45Yrs',40),

    if(Age>=46 and Age<=65,Dual('46-65Yrs',50),

    Dual('>65Yrs',60)))))) as AgeFrame;

    LOAD * INLINE [

    Customer_Name,Age

    Name1,25

    Name2,18

    Name3,20

    Name4,35

    Name5,40

    Name6,17

    Name7,8

    Name8,10

    Name9,15

    Name10,28

    Name11,43

    Name12,48

    Name13,60

    Name14,65

    Name15,70

    Name16,84

    Name17,89

    Name18,91

    Name19,26

    Name20,32

    ];

     

    Capture.JPG