applymap

[#1]

Hi,

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

Thanks!!!

[vikasmahajan]

Please go through this example

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

Hope this help you.

Vikas

[#3]

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]

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

Vikas

[MK_QSL]

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

[#6 · Accepted solution]

Hi Kavita

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

[#7]

Hi Nirmal,

I changed it to SQL and its woking now

Thanks a lot for your help

[#8]

Welcome

[vikasmahajan]

PFA