topic ApplyMap issue in QlikView

ApplyMap issue

Mon, 12 Sep 2011 10:14:12 GMT

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

ApplyMap issue

Mon, 12 Sep 2011 10:42:47 GMT

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

its_anandrjs — Mon, 12 Sep 2011 10:49:05 GMT

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

Re: ApplyMap issue

Mon, 12 Sep 2011 10:54:23 GMT

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

its_anandrjs — Mon, 12 Sep 2011 11:00:55 GMT

Hi,

See the updated attached.

Regards

Anand

Re: ApplyMap issue

Mon, 12 Sep 2011 11:18:28 GMT

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

Re: ApplyMap issue

Mon, 12 Sep 2011 11:21:24 GMT

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..

Re: ApplyMap issue

Mon, 12 Sep 2011 13:02:26 GMT

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

its_anandrjs — Mon, 12 Sep 2011 13:08:11 GMT

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

Re: ApplyMap issue

Mon, 12 Sep 2011 13:13:17 GMT

Yup.. Your correct..

Thanks anyways..

Now it is working fine.