Mapping Load Unknown error

[kevinchevrier]

Hi,

I work on Qlikview v 12.10.20200.0.SR4

I want to do a MapSubstring. So I need to do a MAPPING LOAD before. Qlikview return Unknown error on MAPPING LOAD.

Below is the script we use :

encoding:
MAPPING
LOAD original,
conversion as url
FROM
[..\05_data_externe\encoding.xlsx]
(ooxml, embedded labels, table is Feuil1);

This MAPPING LOAD works fine on an other app. We don't know why it doesn't work as well.

In attachment, you'll find the picture of this error.

Regards,

Kevin

[kevinchevrier]

Hi,

I just deleted it and copy this file from another folder. It still not working.

I also rename my file, not working too.

Thank you,

Kevin

[arvind_patil]

Hi Kevin,

I think you need to try on some sample data lets check is there any version issue.

Thanks,

Arvind Patil

[jmvilaplanap]

And do you use the wizard to load the file? I said because maybe the parameters "(ooxml, embedded labels, table is Feuil1); " are not right

[kevinchevrier]

No it's OK, I use it to be sure the parameters were OK.

[jmvilaplanap]

I think is not the problem, but in mappings is not necessary rename fields, can you try without renaming?

And copy the excel file to the same folder than the qvw?

[lcloatre · Accepted solution]

Do you try that ?

encoding_temp:
//MAPPING
LOAD original,
conversion as url
FROM
[..\05_data_externe\encoding.xlsx]
(ooxml, embedded labels, table is Feuil1);

encoding:
MAPPING
LOAD original,
url
RESIDENT encoding_temp;

drop table encoding_temp;

[kevinchevrier]

Perfect Laurent. I don't understand why but it works...

Thank you.

Kevin