I am getting Custom read Failed Error

gauravgg — Mon, 07 Aug 2017 10:59:11 GMT

Hi all

I am having the following code

I am Extracting data from SAP .

Custom read Failed Error

V_OBJID:

LOAD Distinct

Concat(DISTINCT Chr(39) & OBJECTID & Chr(39), ',') as V_OBJECTID

FROM

(qvd) where match(OBJECTCLAS ,'MATERIAL','MATERIAL_H','MATERIAL_N','MAT_FULL');

LET VMATNR = peek('V_OBJECTID',0,'V_OBJID');

MARD_NEW:

SQL SELECT MATNR FROM MBEW WHERE MATNR IN ($(VMATNR));

Note :-

for example

the variable VMATNR contains '20FTHEAVYDUTY','20FTIMCO-HAZ','20FTMAFI','20FTOPENTOPIG','20FTOPENTOPOOG','20FTREEFER'

Can anyone help me in this .

Thanks in advance

Re: I am getting Custom read Failed Error

Chanty4u — Mon, 07 Aug 2017 11:22:55 GMT

Hi,

Am not sure

just check here

Anil_Babu_Samineni — Mon, 07 Aug 2017 11:39:06 GMT

Concat() must need Group By