Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

applymap

Hi,

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

Thanks!!!

1 Solution

Accepted Solutions
Not applicable

Re: Re: applymap

Hi Kavita

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

8 Replies
vikasmahajan
Honored Contributor III

Re: applymap

Please go through this example

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

Hope this help you.

Vikas

Not applicable

Re: applymap

Hi Vikas,

Thanks for the reply.

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

Regards,

vikasmahajan
Honored Contributor III

Re: applymap

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

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";

Not applicable

Re: Re: applymap

Hi Kavita

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

Not applicable

Re: Re: applymap

Hi Nirmal,

I changed it to SQL and its woking now

Thanks a lot for your help

Not applicable

Re: Re: applymap

Welcome

vikasmahajan
Honored Contributor III

Re: applymap

PFA

Community Browser