I am getting Custom read Failed Error

[gauravgg]

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

[Chanty4u]

Hi,

Am not sure

just check here

https://community.qlik.com/thread/210248

Sap Connector Custom Read Failed

[Anil_Babu_Samineni]

Concat() must need Group By