Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have no idea if this is possible, but i want to achieve this:
excel file shows:
Name | lowest_value | highest_value |
---|---|---|
A | 1 | 5 |
A | 12 | 14 |
B | 20 | 22 |
B | 28 | 29 |
C | 30 | 34 |
I now i would like qlikview to automatically create this table below (in the script!) so I can left join 'Value' with an exitisting 'Value' of another table so the name is added to that table.
Name | Value |
---|---|
A | 1 |
A | 2 |
A | 3 |
A | 4 |
A | 5 |
A | 12 |
A | 13 |
A | 14 |
B | 20 |
B | 21 |
B | 22 |
B | 28 |
B | 29 |
C | 30 |
C | 31 |
C | 32 |
C | 33 |
C | 34 |
You can see that for Name 'A' 5 records have been created with a Value range from 1 to 5 and three records with a range from 12 to 14.
When this table is created I can left join 'Value' with an exitisting 'Value' of another table so the name is added to that table.
Is this possible?
Your help is very much appreciated.
Regards Peter
Try using Iterno() in load with a while clause .
hi,
Check this attach file and let me know.
Regards,
Ashutosh
Yes this works perfect.
I've already implemented this in my project.
Thanks!
Regards,
Peter