Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Regarding the Qualify

Can i use the Qualify statment?, without changing the field name .....

suppose

qualify *

Load a1,a2,a3

from sales.qvd (qvd);

a1 and a2 and a3 field name shld nt be changed whn i am using the Qualify.

3 Replies
Not applicable
Author

Hi,

I`m not sure what you r trying to say.

But if my undersatnding is correct following would be the answer for your question.

qualify *;

unqualify a1,a2,a3;

Load a1,a2,a3

from sales.qvd (qvd);

unqualify *;

- Sridhar

Not applicable
Author

thanx for you ans Sridhar,

I knw this thing watever you metion bt my question is ..

when i am use qualify * then it changes all the field name with logical tablename.field name ..... then it will stop to making a joins ...

my question is i don't want ot change the field name whn i am using this ..... and also avoid the joins..... is tat possible?

Not applicable
Author

I think , it is not possible... you should try to aliasing the fields. No other go , i believe.... Angry

- Sridhar