Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have many tables.
I want to connect together.
I use QUALIFY *; UNQUALIFY respondentID;
Please see my picture. How can I connect tables ( pointed red and blue lines)
Thanks,
HI
Rename the field and qv connect automatcially
ex:
Load Sales as TotalSales from Table1;
Load Total_Sales as TotalSales from Table2;
Qv connect both and display as one field
Hi Vladimir,
you must to use
qualify *;
unqualify [fieldName1], [fieldName2], [fieldName3];
load
f1,
f2,
f3,
f4 as fieldName1
from ....;
unqualify *;
FieldName1,2,3 are your field ID as tagID and questionID.
Regards
Luca Jonathan Panetta