topic Re: restrict qulifer for single table in QlikView

restrict qulifer for single table

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

if we are using qualifier *.it will rename for all table otherwise we should give unqualifier for every table.

ex:

qualifier *,

t1:

load

can we give something like

qualifier t1;

so we can restrict for one table.

we can write write qualifier for particular column ,

but i want for all columns in single table should change

sunny_talwar — Fri, 17 Mar 2017 15:54:49 GMT

I guess add qualify before your table load and unqualify afterwards

QUALIFY *;

t1:

LOAD ...

FROM ....;

UNQUALIFY *;

t2:

LOAD ...

FROM ...;

t1 will be qualified, but t2 won't be

krishna789 — Tue, 21 Mar 2017 06:26:29 GMT

hi i got it thanks

krishna789 — Tue, 21 Mar 2017 06:27:50 GMT

hi thanks