Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be set this
SET ErrorMode=0;
To read more https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ErrorVariables...
as I told you, with error modes table data will be missed
Sincerely, Not make sense to me. But blindly replying to you. So why you want to take D Field then?
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*;
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
thanks for the effort but data is not loading, only error is avoiding
What if you forcibly ignoring the error like Continue / Ok ??
it is automatic triggers, not manual
May be marcus_sommer will light you