Discussion Board for collaboration on QlikView Scripting.
Can anybody please post a sample which uses applymap with SQL.
Go to Solution.
PFA.. Applymap sample application..... but it is not SQL query.........Just test case
Please go through this example
Re: How to Use Apply Map in QV Script with SQL Table
Hope this help you.
Thanks for the reply.
I have already gone through that link. Could you please provide a sample, if you have any?
Apply Map with sql can be base on logic which you want , study the script and apply that logic for your fields.
First Table is Part Description which is Mapping Load Table
Second Table is Purchase/Sales Table in Which I have used ApplyMap to get Part Description...
Hope this help...
OLEDB CONNECT32 TO ......
SQL SELECT PNO,
ApplyMap('PART',PNO, 'UNKNOWN') as PartDescription;
SQL SELECT NETORDQTY,
I changed it to SQL and its woking now
Thanks a lot for your help