restrict qulifer for single table

[krishna789]

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]

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]

hi i got it thanks

[krishna789]

hi thanks