Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am trying to bucket uneven age groups on a resident table. I'd like the buckets to be as follows. I'd like the age group be appended to the resident table. How would I accomplish that?
0 to 14
15-19
20-24
25-29
30-34
35-39
40-44
45-49
50-54
55+
Here's my resident table.
Quotes:
Load
DRIVER_AGE,
POLICY_NUMBER
From C:\QlikView\Daily Quote\v14\CombinedQuotes.qvd (qvd);
Thanks in advance!
Carl
I'm sorry i don't understand. Perhaps post it under a new thread and I will take a look for you.
Your buckets. 0 and 100. If my fact table has negative, or null values or numbers higher than 100 what happens? How would you account for those in your inline load?
The data in my inline load is the age groups you provided on your original question and assumes the DRIVER_AGE in your resident load has positive values (source database shouldn't allow negative values here!)
Bottom line - i'm no expert but if you prepare the inline load according to the data in your fact table, it should do the trick for you.