topic AQL - Association Not Happening in QlikView

AQL - Association Not Happening

Tue, 22 Mar 2011 17:49:54 GMT

Hello,

I'm trying to load data from 3 tables and this is what is script looks like

SQL SELECT "IP_ADDRESS"
FROM SPRTSG4."SPRT_EC_DEVICE";

SQL SELECT "HARDWARE_GUID"
FROM SPRTSG4."SPRT_EC_DEVICE";

SQL SELECT "FIRMWARE_GUID"
FROM SPRTSG4."SPRT_EC_DEVICE";

SQL SELECT GUID AS FIRMWARE_GUID
FROM SPRTSG4."SPRT_EC_FIRMWARE";

SQLSELECT "FIRMWARE_VERSION"
FROM SPRTSG4."SPRT_EC_FIRMWARE";

SQL SELECT GUID AS HARDWARE_GUID
FROM SPRTSG4."SPRT_EC_HARDWARE";

SQL SELECT MANUFACTURER
FROM SPRTSG4."SPRT_EC_HARDWARE";

However association is not happening despite the fact that I have renamed the columns (HARDWARE_GUID) AND (FIRMWARE_GUID) to be the same as the column names from the SPRT_EC_DEVICE table.

Any ideas?

Thanks,

Anton

AQL - Association Not Happening

rwunderlich — Tue, 22 Mar 2011 18:36:49 GMT

The above script will create a bunch of single field tables, which I don't think is what you want. I think your script should look something like like this.

Device:
SQL SELECT "IP_ADDRESS", "HARDWARE_GUID", "FIRMWARE_GUID"
FROM SPRTSG4."SPRT_EC_DEVICE";

Firmware:
SQL SELECT GUID AS FIRMWARE_GUID, "FIRMWARE_VERSION"
FROM SPRTSG4."SPRT_EC_FIRMWARE";

Hardware:
SQL SELECT GUID AS HARDWARE_GUID, MANUFACTURER
FROM SPRTSG4."SPRT_EC_HARDWARE";

AQL - Association Not Happening

Tue, 22 Mar 2011 19:21:31 GMT

That Worked.

Thank you Rob.

- Anton