Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
zagzebski
Creator
Creator

Transforming multiple excel spreadsheets in Qlikview

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?)

Transition.png

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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.

View solution in original post

2 Replies
swuehl
MVP
MVP

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.

zagzebski
Creator
Creator
Author

Thanks - Makes sense.

Zag