Problem in Split one filed into two fileds with in Load Script

[#1]

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.

[sasiparupudi1]

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;

[#3]

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

[#4 · Accepted solution]

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.

[Ralf-Narfeldt]

Great! Please remember to mark the question as Answered and set replies as Helpful/Correct!