topic Not load field in QlikView

Not load field

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

Hi Community,

I don't wanted to load particular field for the below scenario.

I have 2 tables

1. TabA

Fields:

2. TabB

Fields:

Now in dashboard I am loading table like below.

Table:

Load * From Tab*;

Now I am getting synthetic keys so I don't wanted to load Field C by using

Table:

Load * From Tab*

where ?;

How can I achieve this scenario.

- Priya

Re: Not load field

Kushal_Chawda — Tue, 12 Apr 2016 06:41:11 GMT

I am still unclear but can't you comment the field C from table and then load it?

Re: Not load field

engishfaque — Tue, 12 Apr 2016 06:44:51 GMT

Dear Priya,

You can do it by using, Comment, Rename, Alias, Qualify/UnQualify or Drop your Field "C".

Kind regards,

Ishfaque Ahmed

Re: Not load field

priyarane — Tue, 12 Apr 2016 06:45:17 GMT

Hi Kushal,

I have to use like

Load * From Tab*

Re: Not load field

Kushal_Chawda — Tue, 12 Apr 2016 06:51:53 GMT

If you don't have same number of field with same name then FROM tab* will not work. But still you can use loop to concatenate the same.

Re: Not load field

priyarane — Tue, 12 Apr 2016 06:57:15 GMT

Hi Kushal,

Do you have sample Loop

Re: Not load field

Kushal_Chawda — Tue, 12 Apr 2016 07:03:56 GMT

Data:

LOAD * inline [

Junk ];

For each vFileName from filelist('path\*.qvd')

Concatenate(Data)

LOAD *

FROM $(vFileName )(qvd);

NEXT vFileName ;

drop field Junk;