Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Tags (1)
9 Replies
Not applicable

ApplyMap issue

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

Re: ApplyMap issue

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

Re: ApplyMap issue

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?

Re: ApplyMap issue

Hi,

See the  updated attached.

Regards

Anand

Not applicable

Re: ApplyMap issue

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

Not applicable

Re: ApplyMap issue

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

Re: ApplyMap issue

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

Re: ApplyMap issue

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

Re: ApplyMap issue

Yup.. Your correct..

Thanks anyways.. 

Now it is working fine.

Community Browser