Discussion Board for collaboration on QlikView Security and Governance.
i have the following case in section access:
Is there any way to autogenerate the values of RegionID, since the values are well defined for the same user from 01-00-00 till 09-09-09?
Go to Solution.
load num(rowno(), '00') as R1 AutoGenerate 9;
join (R) load num(rowno()-1, '00') as R2 AutoGenerate 10;
join (R) load num(rowno()-1, '00') as R3 AutoGenerate 10;
Left join (R) load *, text(R1 & '-' & R2 & '-' & R3) as AllRegion Resident R;
(html, codepage is 1252, embedded labels, table is @1);
join (S) load AllRegion as Region Resident R;
DROP Table R;
Not related to your question - but you must use REGIONID instead of RegionID if you want to use it for data reduction.
Solved!! Thank you Massimo, and Thank you all guys.