topic Re: Re: applymap in QlikView

applymap

Thu, 30 Jan 2014 09:13:54 GMT

Hi,

Can anybody please post a sample which uses applymap with SQL.

Thanks!!!

Re: applymap

vikasmahajan — Thu, 30 Jan 2014 09:15:36 GMT

Please go through this example

Re: How to Use Apply Map in QV Script with SQL Table

Hope this help you.

Vikas

Re: applymap

Thu, 30 Jan 2014 09:20:22 GMT

Hi Vikas,

Thanks for the reply.

I have already gone through that link. Could you please provide a sample, if you have any?

Regards,

Re: applymap

vikasmahajan — Thu, 30 Jan 2014 09:29:09 GMT

Apply Map with sql can be base on logic which you want , study the script and apply that logic for your fields.

Vikas

Re: applymap

MK_QSL — Thu, 30 Jan 2014 09:33:18 GMT

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 ......

PART:

MAPPING LOAD

PNO,

DESC1;

SQL SELECT PNO,

DESC1

FROM PPMSDB1.dbo."KCF_PRODF_ACTV";

PURCHASE:

LOAD *,

ApplyMap('PART',PNO, 'UNKNOWN') as PartDescription;

LOAD NETORDQTY,

PNO;

SQL SELECT NETORDQTY,

PNO

FROM PPMSDB1.dbo."PMS_SALES";

Re: Re: applymap

Thu, 30 Jan 2014 09:39:35 GMT

Hi Kavita

PFA.. Applymap sample application..... but it is not SQL query.........Just test case

Re: Re: applymap

Thu, 30 Jan 2014 10:51:44 GMT

Hi Nirmal,

I changed it to SQL and its woking now

Thanks a lot for your help

Re: Re: applymap

Thu, 30 Jan 2014 10:59:57 GMT

Welcome

Re: applymap

vikasmahajan — Thu, 30 Jan 2014 11:04:18 GMT

PFA