Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Frnz,
I want some data in AMID_ID filed. so i have taken AMID from AMID_ID by using some condition. It is not working, something problem in load script. Please find the attached QVW.
LOAD YEAR,
AMID_ID,
Sale //,
//if(not WildMatch (AMID_ID,'zzz*'),AMID_ID,'na'&Right(AMID_ID,1)) as AMID
FROM
C:\sasi\qv\Demo_Split_filed.xls
(biff, embedded labels, table is [Sheet1$])
where WildMatch (AMID_ID,'zzz*')=0;
Hi,
I need Two fileds. I want ZZZ acounts include filed and Other than ZZZ acounts field..So is it possible.
AMID_ID ====>> All acounts ids
AMID=====>> Ohter than ZZZ ids
Hi to All,
Now i got.For this In IF condition i have to give third parameter. I dnt want that in front end ,so i have filter in front end this third paramter value..
My Expression: if(wildmatch(AMID_ID,'zzz*')<>1,AMID_ID,'TTTT') as AMID
So i dnt want TTTT in front end, so i have written if condition in front end.
Thanks to all help me a lot.
Great! Please remember to mark the question as Answered and set replies as Helpful/Correct!