Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Please explain the script

//Dynamic IntervalMatch mapping
//Alexander Karlsson - Ze Demoz Teamz - 2013-09-24

//Point to your excel file
temp:
LOAD DISTINCT FieldName
FROM
RiskData.xlsx
(
ooxml, embedded labels, table is [Bucket Templates]);

LET noRows = NoOfRows('temp');

for j=0 to $(noRows)-1
let vFieldValue = peek('FieldName',$(j),'temp');
let vFieldEncoded = '[$(vFieldValue)]';

$(vFieldEncoded):
LOAD FieldName,
StartRange,
EndRange,
Label as [$(vFieldValue) Bucket],
SortOrder as [$(vFieldValue) BucketSort]
FROM
RiskData.xlsx
(
ooxml, embedded labels, table is [Bucket Templates]) where FieldName = '$(vFieldValue)';

IntervalMatch($(vFieldEncoded))
Left Join ($(vFieldEncoded)) Load StartRange,EndRange Resident $(vFieldEncoded) where FieldName = '$(vFieldValue)';

Next

DROP TABLE temp;
Drop Fields StartRange,EndRange,FieldName;

Please explain the purpose of the script.Apologies.

Labels (1)
0 Replies