topic How to ignore missing field? in QlikView

How to ignore missing field?

Anonymous — Fri, 22 Sep 2017 11:38:57 GMT

Colleagues, good day!
Can you give an advice please, how we can ignore missing field in Table loading statement?

For example, i have this one:

Test:

Load * Inline

[A, B, C];

Final:

load

resident Test;

Drop table Test;

How to ignore D field missing and to load A, B, C without fails?

Thanks.

Gysbert_Wassenaar — Fri, 22 Sep 2017 11:44:05 GMT

You can't. Do try to load non-existing fields. It will not work.

If you want to load all the fields from table Test the do LOAD * RESIDENT Test;

That will work even if you don't know which fields table Test does or does not have.

Anonymous — Fri, 22 Sep 2017 11:46:08 GMT

Can you show me please how to do that?

swuehl — Fri, 22 Sep 2017 11:49:49 GMT

Gysbert alread showed it using LOAD * RESIDENT Test;

But don't forget to use NOCONCATENATE when using LOAD * RESIDENT ...

Test:

Load * Inline [

A, B, C

1,2,3 // just to add a record

];

Final:

NOCONCATENATE

load

resident Test;

Drop table Test;

swuehl — Fri, 22 Sep 2017 11:51:18 GMT

But can you describe what the use case for this is? Maybe there is a different but better solution.

Anonymous — Fri, 22 Sep 2017 12:02:03 GMT

i need to understand, in what way (maybe through the variable) i can check if table exist some field

swuehl — Fri, 22 Sep 2017 13:08:55 GMT

You can make use of the table functions: