Field not found with table load

[priyarane]

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

[Anil_Babu_Samineni]

May be set this

SET ErrorMode=0;

To read more https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ErrorVariables...

[priyarane]

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

[Anil_Babu_Samineni]

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

[priyarane]

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*;

[Anil_Babu_Samineni]

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

[priyarane]

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

[Anil_Babu_Samineni]

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

[priyarane]

it is automatic triggers, not manual

[Anil_Babu_Samineni]

May be marcus_sommer‌ will light you