determine field name when loading

Tue, 10 Feb 2015 16:58:01 GMT

I am struggling with the syntax on how to do the following:

Load TableA with 3 data fields from 4 differnet Excel files. The data is indentical in every file, but the field name to which the last data field from the Excel files gets loaded needs to be different, depending on which Excel file is being read at the time.

so:

pseudo code:

for each file in list

load fieldA as "A",

fieldB as"B",

fieldC as "what goes here? it depends on the name of the file"

any ideas?

thanks.

Re: determine field name when loading

maxgro — Tue, 10 Feb 2015 17:13:17 GMT

if I understand

PFA

Re: determine field name when loading

Tue, 10 Feb 2015 17:37:28 GMT

THanks for quick and good response!

topic Re: determine field name when loading in QlikView

determine field name when loading

Re: determine field name when loading

Re: determine field name when loading