Script error

[smilingjohn]

Hi ,

In The script i am trying to add the below expression but this is giving an error during reload process. load

Release,

if(not match(Status,'Defined','In Progress'),Release='Blank',Release) as RNUmber

Resident Test

Group by [Release],[Status];

how can i correct this

Thanks in advance

[ogautier62 · Accepted solution]

Hi,

maybe this :

if(not match(Status,'Defined','In Progress'),'Blank',Release) as RNUmber

remove : release=

regards

[smilingjohn]

Hi Oliver,

Thanks this works ..

Actually i want to discard the whole content if there is Defined or in progress in it.

For which the above logic is not working ...

How do i achieve this

[ogautier62]

to have null :

if(not match(Status,'Defined','In Progress'),,Release) as RNUmber

if you want to skeep row :

add where match(Status,'Defined','In Progress') =0 in load

[gavinigovind452]

using above answer not getting error

[SalesPersonSales201806]:

LOAD * INLINE [

    Short_ID, Month

    1, AUG

    2, SEP

    3, DEC

    4, SEP

    5, SEP

    6, OCT

    7, JAN

    8, AUG

];

Tab:

load Short_ID,

if (not match(Month,'AUG','SEP'),'Blank','YES') as tert

Resident [SalesPersonSales201806];

getting below result:

Short_ID	Month	tert
1	AUG	YES
2	SEP	YES
3	DEC	Blank
4	SEP	YES
5	SEP	YES
6	OCT	Blank
7	JAN	Blank
8	AUG	YES