topic Re: Is this something QlikView can’t do? Skip missing fields in Water Cooler

Is this something QlikView can’t do? Skip missing fields

danm84306 — Thu, 21 Aug 2014 16:09:14 GMT

Based on countless hours of looking and replies to similar posts, I am guessing that you cannot skip a field in a load statement if the field does not exist. I am trying to load 1 field from multiple files that may have up to 7 different names but they all mean the same thing. The field is not always in the same column on each file. I am looking to simply skip the field if the name does not exist.
1 name will exist but only 1 of the 7 so I want to call all 7 fields but skip if the field is not listed.

Example:

Find OptionA, OptionB, OptionC, OptionD,OptionE, OptionF , or OptionG and call it OptionH

Re: Is this something QlikView can’t do? Skip missing fields

rwunderlich — Thu, 21 Aug 2014 16:11:04 GMT

See

Challenge! No one has the right answer do far! Skip missing field.

And please refrain from double posting.

-Rob

Re: Is this something QlikView can’t do? Skip missing fields

jagan — Thu, 21 Aug 2014 16:15:06 GMT

Hi Donald,

With in a single load statement it is not possible, if you want it in a single statement then use * in Load statement.

Regards,

Jagan.

Re: Is this something QlikView can’t do? Skip missing fields

danm84306 — Thu, 21 Aug 2014 16:32:13 GMT

I can load all fields but the number of files, columns, and rows would take too long to pull. i just ran a test with 1 folder and 25 files with LOAD *. it has been 5 minutes and it is still going.

Re: Is this something QlikView can’t do? Skip missing fields

martynlloyd — Thu, 21 Aug 2014 16:55:09 GMT

Hi Donald,

And please refrain from triple posting!

Load multiple fields with different name into one.

Regards,

Re: Is this something QlikView can’t do? Skip missing fields

jagan — Fri, 22 Aug 2014 01:29:45 GMT

Hi Donald,

I think there is no other solution.

Regards,

Jagan.