Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Accepted Solutions
Andres - review your code. When you load table Exit_Survey from the QV_DataBase.xlsx you never create a field called "BUSINESS UNIT', instead you combine this field with four others and call the result [%Key field]. When you load the Link Table you resident load Exit_Survey and tell it to load a field called "BUSINESS UNIT' - which does not exit (hence your error).
You could fix this a few ways. You could add some new fields to "Exit_Survey" called ES_BUSINESS_UNIT, and then when loading the Link Table resident load ES_BUSINESS_UNIT as 'BUSINESS UNIT'. Another way would be to not resident load, but actually load again from QV_DataBase.xlsx into the Link Table. However you choose to correct it you are referencing a field you didn't include in the table. The solution is to add it to the table.
BUSINESS UNIT does not exist in the Exit_Survey table:
Qlik's error is very literal - "You said there is a field in the table Exit_Survey called 'BUSINESS UNIT', but there isn't....
You could try this:
LinkTable::
Load DISTINCT
`BUSINESS UNIT` & '|' & `CLUSTER`& '|' & `COUNTRY` & '|' & `LOCATION` & '|' & `MONTH` As [%Key field],
`BUSINESS UNIT`,
`CLUSTER`,
`COUNTRY`,
`LOCATION`,
`MONTH`
FROM
Andres - review your code. When you load table Exit_Survey from the QV_DataBase.xlsx you never create a field called "BUSINESS UNIT', instead you combine this field with four others and call the result [%Key field]. When you load the Link Table you resident load Exit_Survey and tell it to load a field called "BUSINESS UNIT' - which does not exit (hence your error).
You could fix this a few ways. You could add some new fields to "Exit_Survey" called ES_BUSINESS_UNIT, and then when loading the Link Table resident load ES_BUSINESS_UNIT as 'BUSINESS UNIT'. Another way would be to not resident load, but actually load again from QV_DataBase.xlsx into the Link Table. However you choose to correct it you are referencing a field you didn't include in the table. The solution is to add it to the table.
BUSINESS UNIT does not exist in the Exit_Survey table:
Qlik's error is very literal - "You said there is a field in the table Exit_Survey called 'BUSINESS UNIT', but there isn't....
You could try this:
LinkTable::
Load DISTINCT
`BUSINESS UNIT` & '|' & `CLUSTER`& '|' & `COUNTRY` & '|' & `LOCATION` & '|' & `MONTH` As [%Key field],
`BUSINESS UNIT`,
`CLUSTER`,
`COUNTRY`,
`LOCATION`,
`MONTH`
FROM
