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

[tresesco]

Script looks good. Could it be a similar issue like explained here: Re: QV 12.10 - mapping load * inline fails ?

[zhadrakas]

did you try to use the absolute path to the Excel file?

[kevinchevrier]

Yes

[zhadrakas]

is there a Directory command in your script before this mapping load?

[kevinchevrier]

No, it's on my computer

[kevinchevrier]

I had a look on that but I don't know where I can find the Roaming File.

[tresesco]

Path could be something like:

C:\Users\<User Name>\AppData\Roaming\Microsoft\Crypto

Note: AppData folder is usually a hidden folder

[kevinchevrier]

I delete the Crypto folder but it still not working. A new Crypto file is created each time I reload my app.

[jmvilaplanap]

Hi,

Try to create a copy of this excel and use it, maybe your excel file is corrupted or something like this.

Regards