topic Transforming multiple excel spreadsheets in Qlikview in QlikView

Transforming multiple excel spreadsheets in Qlikview

zagzebski — Tue, 26 Apr 2016 23:13:20 GMT

I have a project to load roughly 200 excel spreadsheets into QlikView. The spreadsheets can have different column names for the same data. So I need to:

1. Sweep through each excel file in a specific directory

2. transform (rename) each "field" to the required "master field" - (create a metadata transition table?)

Re: Transforming multiple excel spreadsheets in Qlikview

swuehl — Tue, 26 Apr 2016 23:22:57 GMT

For 1., you can look into a FOR EACH vFile in FILELIST(...) loop (examples in the HELP) to iterate over all excel files.

Then load each file and apply a RENAME FIELDS USING MetaDataMap (see also the HELP for RENAME statement).

[Alternatively, use ALIAS before the LOADs]

Then store the files to QVDs or concatenate into one table.

Re: Transforming multiple excel spreadsheets in Qlikview

zagzebski — Tue, 26 Apr 2016 23:35:01 GMT

Thanks - Makes sense.

Zag