topic i am getting error in mapping 2 tables in QlikView

i am getting error in mapping 2 tables

Thu, 16 Dec 2010 05:41:05 GMT

iselect two tables
one is
Customermaster and another is Transtock table

mappping

applymap('CustomerMaster', CompanyID) as CustomerName
then it will display error message

"mapping requires 2-Column input"
i will change field name one or more
then i am getting same error
what is the reason?
give me a Hint for me

i am getting error in mapping 2 tables

hemalatha — Thu, 16 Dec 2010 06:19:30 GMT

Hi Sampath,

Please ensure that you have the below kind of scripting for applymap in your code.

Customermaster:

mapping load * inline [

CompanyID, CustomerName

111,A

222,B

333,C];

Transtock:(if this is where you want to use applymap, otherwise change the table name as appropriate)

applymap('Customermaster',CompanyID) as CustomerName // this will provide the corresponding customername of the CompanyID which presents in the Customermaster table

Please note in this, the mapping table(i.e Customermaster) table will not be visible in the table structure.

Regards,

Hema

i am getting error in mapping 2 tables

Thu, 16 Dec 2010 07:27:25 GMT

Thanks for reply.

But still iam getting same error.

i am getting error in mapping 2 tables

Anonymous — Thu, 16 Dec 2010 07:38:22 GMT

Hard to say without seeing the script but you first mention the name Customermaster and then use CustomerMaster in the applymap() function. Check spelling to make sure you're not crashing there.