topic Apply Map in Select for Where in QlikView

Apply Map in Select for Where

cristianj23a — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys.

I have a doubt about the applymap,

There is a way to apply applymap in the Select.

I currently have 2 tables.

One that has a registration date and another does not. I want to enter the registration date to table 2, through the key field BELNR but in Select and do a Where in table two, so that the data is added daily.

TABLE1:

SELECT

CPUDT

BELNR, // DocumentNo //******************************LLAVE*****************************************//

GJAHR, // Fiscal Yr

VERSN, // Version

FROM COBK WHERE VRGNG='COIN' AND CPUDT>'$(vFecMaxCOBK)';

TABLE2:

SELECT BUZEI, // Post. row

KOKRS, // CO Area

BELNR, // DocumentNo //******************************LLAVE****************************************//

PERIO, // Period

GJAHR, // Fiscal Yr

PRODPER // Prod.Month

FROM COEP WHERE KOKRS='1000' AND WRTTP='04' AND VERSN='000' AND LEDNR='00';

Greetings.

Re: Apply Map in Select for Where

passionate — Thu, 19 Apr 2018 15:45:11 GMT

Please post sample data and explain a bit more.

because i done see registration date in any of these two tables

Re: Apply Map in Select for Where

sasiparupudi1 — Thu, 19 Apr 2018 16:54:24 GMT

no you can not use applymap in a select statement.

You will have to use a resident load of table2..

Map_CPUDATE:

Mapping Load

CPUDT,

BELNR

Resident TABLE1;

TABLE2_New:

Noconcatenate load

BUZEI, // Post. row

KOKRS, // CO Area

BELNR, // DocumentNo //******************************LLAVE****************************************//

PERIO, // Period

GJAHR, // Fiscal Yr

PRODPER ,

APPLYMAP('Map_CPUDATE',BELNR,'NA') AS NewDate

Resident TABLE2

WHERE APPLYMAP('Map_CPUDATE',BELNR,'NA')>'$(today())'

;

Drop table TABLE2;