Please explain this cod.

arethaking — Wed, 25 Nov 2020 16:16:04 GMT

//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)';

DROP TABLE temp;

Drop Fields StartRange,EndRange,FieldName;

Re: Please explain this cod.

robert_mika — Thu, 21 Jul 2016 16:14:35 GMT

It will loop thru Sheets(tabs) in

RiskData.xlsx

based on FieldName.