Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

i am getting error in mapping 2 tables

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

3 Replies
hemalatha
Contributor
Contributor

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



Not applicable
Author

0k

Thanks for reply.

But still iam getting same error.

Anonymous
Not applicable
Author

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.