topic Load only field contains ID in QlikView

Load only field contains ID

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

I need to load only field contains ID. How can I do this in the load script.

Where Clause would work but could take a longer time to load. It would be great if you suggest other options.

where clause in SQL statement

T1:

LOAD Distinct

ID,

Key,

Parameter;

SQL SELECT *

FROM "Server"."Prod".table1;

Re: Load only field contains ID

Frank_Hartmann — Wed, 26 Sep 2018 09:06:37 GMT

maybe like that:

tmp0:
LOAD * INLINE [
    Field1, Field2, Field3
    213, sd, hj
    436, ggrer, uzt
    5467, sdf, uzk
    76, ght, fr
    687, dd, rr
    , trh, jzt
    , rzt, ziu
    , , olöoi
];
NoConcatenate
tmp1:
Load If(len(Field1)>0,Field1,Null()) as Field1, 
If(len(Field1)>0,Field2,Null()) as Field2,
If(len(Field1)>0,Field3,Null()) as Field3
Resident tmp0; DROP Table tmp0;

Re: Load only field contains ID

karan_kn — Wed, 26 Sep 2018 12:55:53 GMT

Thanks for the response, can you help me within the sql load statement?

Re: Load only field contains ID

Frank_Hartmann — Wed, 26 Sep 2018 13:24:42 GMT

You can use Resident Load:

T1:
LOAD Distinct
ID,
Key,
Parameter;
SQL SELECT *
FROM "Server"."Prod".table1;


T2:
Load 
If(len(ID)>0,ID,Null())as ID,
If(len(ID)>0,Key,Null())as Key,
If(len(ID)>0,Parameter,Null())as Parameter
Resident T1; DROP Table T1;

Re: Load only field contains ID

karan_kn — Wed, 26 Sep 2018 13:44:54 GMT

Thanks Frank