Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ApplyMap issue

Hi All,

I am using Qlikview10.

Please find attached of the qvd file.

Please see the script(edit script) while debugging it, it is giving me Field not found error.

There you can see there is a condition of "ApplyMap". If I will comment this then it is executing fine..

Kindly please suggest why it is behaving so..

Thanks,

Sandeepa

9 Replies
Not applicable
Author

hello,

i think your mapping load is wrong

Map_BrickList:

Directory;

Mapping LOAD BRICK,

                         [BRICK NAME]

FROM

[SALESFORCE INCLUSION LISTS 20100917.xls]

(biff, embedded labels, table is [BRICK INCLUSION LIST$]);

so it should be work

its_anandrjs

Hi Sandeepa,

Small error in the mapping table

unnecesary  use of

'Included'

//    [BRICK NAME]

and there is no name of the field also un comment the [BRICK NAME] field like and give name to table also

Map_BrickList:

Mapping LOAD BRICK,

    [BRICK NAME]

FROM

[SALESFORCE INCLUSION LISTS 20100917.xls]

(biff, embedded labels, table is [BRICK INCLUSION LIST$]);

HTH

Regards,

Anand

Not applicable
Author

Can you please send me the modified qvd file..

Actually I have to map the excel sheet to my table.

The excel sheet contains the List of Bricks ; I have to compare it to the table brickno values..

Does it make sense?

its_anandrjs

Hi,

See the  updated attached.

Regards

Anand

Not applicable
Author

Sorry, I can't able to open the file.. It's giving me an error..

Not applicable
Author

I need to map the excel file to my table Values. so I have used "included" and I have uncomment BrickName because if it will be there and I will use ApplyMap it will give an error " 2 mapping columns should be available".

Please upload your modified qvd file..

Not applicable
Author

Hi All,

That issue is resolved . It was giving me error because I have used the wrong field name in the ApplyMatch query.

Thanks,

Sandeepa

its_anandrjs

Hi,

Sorry to response you late due to some system problem,Thats i am saying your load syntax has some errors and check it, you find the error where it is got in your application ok it is nice.

Always check the load script and when use apply map the mapping table name should be correct.

I am not able to reload your file thats why i am not upload it.

Regards

Anand

Not applicable
Author

Yup.. Your correct..

Thanks anyways.. 

Now it is working fine.