topic how will i join differnt column name in two tables in QlikView

how will i join differnt column name in two tables

Thu, 09 Dec 2010 09:34:55 GMT

two table are present in the database both have the same field but with different names.

how will i join both(table name- summary_pcs and x)

test:
SQL SELECT * FROM summary_pcs;

//store Qlikview Table from memory to disk

store test into E:\qlikview\test.qvd (qvd);

LOAD
CHARGING_PROFILE_TYPE_ID,timestamp(EVENT_DATE,'DD/MMYY'),CONTENT_PROFILE_ID,CONTENT_ID,APC_QUERY_NOT_OK_COUNT
FROM test.QVD (QVD);

how will i join differnt column name in two tables

Miguel_Angel_Baeyens — Thu, 09 Dec 2010 09:46:33 GMT

Hello,

I feel I'm missing something, anyway, a join should look like

TablefromDatabase:LOAD KeyField, Field1, Field2;SQL SELECT KeyField, Field1, Field2FROM Table1; TablefromFile: // Not needed, used for clarifying codeINNER JOIN LOAD FileFieldKey AS KeyField, Field3, Field4FROM File.qvd (qvd);

Renaming the field will allow you to join correctly both tables.

Hope this helps