"Invalid load model" help!!

[davehutchinson]

Hi everyone, I've encountered an issue with loading a mapping table that started last week on a table I've been using without issue for months.

When loading a mapping table I now get the error "Invalid load model":

but I have no idea what the issue is.  The error message says:

"The following error occurred: Table ' ' not found"

but I am stumped as to what table its referring to?  

I assuming there's an issue with my mapping load statement, but I can't see an issue with it?

Here's the loading of the mapping table:

Here's a storing of the mapping table data:

Can anyone help?

the mapping was working fine until last week.

Thanks

[marcus_sommer · Accepted solution]

A mapping-table is a special kind of table within Qlik which couldn't be stored or accessed in any way unless the use of the functions applymap() and mapsubstring() or with a map use statement. These tables exists only within the script-execution and are dropped by finishing the script.

If you want to store these two fields from the Excel load you just need to remove the mapping-prefix before the load-statement.

[rubenmarin · Accepted solution]

Hi, the mapping tables are not loaded on the model, so you can't do a Store of those tables, maybe you can load as a regular table to make the store and load as mapping table where you need to use the ApplyMap() function.

[davehutchinson]

I managed to sort this in the end, but had to get help so not exactly sure what they did in the end.  But working now!! Thanks