Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
0k
Thanks for reply.
But still iam getting same error.
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.