topic Re: Field not found with table load in QlikView

Field not found with table load

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

Hi Community,

Is there any way to load table even if Field not found error, with error modes we can avoid failure but we can't load rest of the load.

for Ex:

table:

load*,if(d='a','te','be') as test_flat

from table;

above table d field is not there but we need to avoid failure as well as need to load other fields. it should be dynamic as I mentioned only one field like 'd', but in real there are couple of tables and couple of fields..

-Priya

Re: Field not found with table load

Anil_Babu_Samineni — Wed, 21 Mar 2018 13:12:56 GMT

May be set this

SET ErrorMode=0;

Re: Field not found with table load

priyarane — Wed, 21 Mar 2018 13:15:03 GMT

as I told you, with error modes table data will be missed

Re: Field not found with table load

Anil_Babu_Samineni — Wed, 21 Mar 2018 13:18:29 GMT

Sincerely, Not make sense to me. But blindly replying to you. So why you want to take D Field then?

Re: Field not found with table load

priyarane — Wed, 21 Mar 2018 13:24:09 GMT

dynamically picking data from qvds from more than 20 months data and as per the current requirement we might add new logic and we are not aware that field exist in previous months as DB guys might added as per the new requirements so we should avoid these errors.

for Ex:

select

*,if(d='a','te','be') as test_flat

from qvd_month*;

Re: Field not found with table load

Anil_Babu_Samineni — Wed, 21 Mar 2018 13:32:39 GMT

Can you try this way

set ErrorMode=0;

select

*,if(d='a','te','be') as test_flat

from qvd_month*;

if ScriptError=8 then

exit script;

end if

Re: Field not found with table load

priyarane — Wed, 21 Mar 2018 13:34:41 GMT

thanks for the effort but data is not loading, only error is avoiding

Re: Field not found with table load

Anil_Babu_Samineni — Wed, 21 Mar 2018 13:37:39 GMT

What if you forcibly ignoring the error like Continue / Ok ??

Re: Field not found with table load

priyarane — Wed, 21 Mar 2018 13:41:56 GMT

it is automatic triggers, not manual

Re: Field not found with table load

Anil_Babu_Samineni — Wed, 21 Mar 2018 13:45:49 GMT

May be marcus_sommer‌ will light you

Re: Field not found with table load

marcus_sommer — Wed, 21 Mar 2018 13:56:59 GMT

It's not possible to check the existence of a field within a load-statement. You will always need an additionally outside check if a field exists or not. This could be done by loading only the the first record of a file and then looping through all fields and checking them against your conditions and using this to branch into different load-statements.

By qvd-files is it a bit easier because with the qvd-functions these information could be gathered by reading the qvd-header maybe in this way:

for i = 1 to qvdnooffields('YourQVD')

let vFieldCheck = match(qvdfieldname('YourQVD', $(i)), 'd');

if $(vFieldCheck) = true() then

exit for

end if

if $(vFieldCheck) = true() then

LoadStatement1

else

LoadStatement2

end if

Easier then this will be just to use different folders for the different qvd-structures and using then two different load-statements.

- Marcus

Re: Field not found with table load

Anil_Babu_Samineni — Wed, 21 Mar 2018 14:09:00 GMT

Just to know, Can't we do like this?

for i = 1 to qvdnooffields('YourQVD')

let vFieldCheck = match(qvdfieldname('YourQVD', $(i)), 'd');

if $(vFieldCheck) = true() then

LoadStatement1

else

LoadStatement2

end if

next