Faceing Problem with Subfield

[jagannalla]

Hi,

I've a variable vTotal= GoodReads,MissingReads,NoReads

Now by using subfield i'm dividing GoodReads,MissingReads,NoReads in seperate variables i.e vA=SubField(vTotal,',',1) 

vB=SubField(vTotal,',',1)

vB=SubField(vTotal,',',1)

When i using this variables in edti script i'm not able load qvd file error

- The script is like this

LOAD

    Total

where (Total='$(vA)');  

LOAD

     RowNo()as Sno,

     if(Total='No Read','NoReads',if(Len(CTCateg)>0,'GoodReads','MissingReads'))as Total,

From Table1.qvd;

[lironbaram · Accepted solution]

hei

try this script

let vTotal= 'GoodReads,MissingReads,NoReads';

LET vA=SubField(vTotal,',',1) ;

Let vB=SubField(vTotal,',',2);

LET vC=SubField(vTotal,',',3);

LOAD
    B,
    Total

where (Total='$(vA)');  
LOAD * INLINE [
    Total, B
    GoodReads, 11
    MissingReads, 12
    NoReads, 14
    GoodReads, 24
    MissingReads, 56
    NoReads, 67
];

[jagannalla]

Thanks liron baram...it's working