Load many tables

[Anonymous]

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,

[MayilVahanan]

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

[pljsoftware]

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

PLJ Software