topic Re: Mapping Load Unknown error in QlikView

Mapping Load Unknown error

kevinchevrier — Thu, 20 Jul 2017 09:13:25 GMT

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

Re: Mapping Load Unknown error

tresB — Thu, 20 Jul 2017 09:26:57 GMT

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

Re: Mapping Load Unknown error

zhadrakas — Thu, 20 Jul 2017 09:40:29 GMT

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

Re: Mapping Load Unknown error

kevinchevrier — Thu, 20 Jul 2017 09:41:13 GMT

Yes

Re: Mapping Load Unknown error

zhadrakas — Thu, 20 Jul 2017 09:44:43 GMT

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

Re: Mapping Load Unknown error

kevinchevrier — Thu, 20 Jul 2017 09:46:42 GMT

No, it's on my computer

Re: Mapping Load Unknown error

kevinchevrier — Thu, 20 Jul 2017 09:47:38 GMT

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

Re: Mapping Load Unknown error

tresB — Thu, 20 Jul 2017 09:52:12 GMT

Path could be something like:

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

Note: AppData folder is usually a hidden folder

Re: Mapping Load Unknown error

kevinchevrier — Thu, 20 Jul 2017 12:29:19 GMT

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

Re: Mapping Load Unknown error

jmvilaplanap — Thu, 20 Jul 2017 12:33:44 GMT

Hi,

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

Regards

Re: Mapping Load Unknown error

kevinchevrier — Thu, 20 Jul 2017 12:47:33 GMT

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

Re: Mapping Load Unknown error

arvind_patil — Thu, 20 Jul 2017 13:02:28 GMT

Hi Kevin,

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

Thanks,

Arvind Patil

Re: Mapping Load Unknown error

jmvilaplanap — Thu, 20 Jul 2017 13:03:03 GMT

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

Re: Mapping Load Unknown error

kevinchevrier — Thu, 20 Jul 2017 13:04:50 GMT

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

Re: Mapping Load Unknown error

jmvilaplanap — Thu, 20 Jul 2017 13:09:36 GMT

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?

Re: Mapping Load Unknown error

lcloatre — Thu, 20 Jul 2017 13:13:48 GMT

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;

Re: Mapping Load Unknown error

kevinchevrier — Thu, 20 Jul 2017 13:15:38 GMT

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

Thank you.

Kevin