Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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?
Hi,
See the updated attached.
Regards
Anand
Sorry, I can't able to open the file.. It's giving me an error..
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..
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
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
Yup.. Your correct..
Thanks anyways..
Now it is working fine.