Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

combine as new table by columm description with several condition (script)

Hi guys

Ive got following script

Load Date,

Code1,

Code2,

Code3,

If(Wildmatch(Code1,'T83400','Service') as Ser.A

If(Wildmatch(Code1,'T83500','Buy') as Buy.A

If(Wildmatch(Code2,'DE7011*','Sell') as Sell.A

If(Code3="DE123" or Code3="DE124", 'New') as New.A

Now I want a List with all the If()s that I've created like

Type, Titel

1,Service

2,Buy

3,Sell

4,New

which way is the best to list them?

thx much

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Create the field in the same load statement:

Load Date,

Code1,

Code2,

Code3,

If(Wildmatch(Code1,'T83400'),'Service') as Ser.A,

If(Wildmatch(Code1,'T83500'),'Buy') as Buy.A,

If(Wildmatch(Code2,'DE7011*'),'Sell') as Sell.A,

If(Code3="DE123" or Code3="DE124", 'New') as New.A,

If(Wildmatch(Code1,'T83400'),'Service',

     If(Wildmatch(Code1,'T83500'),'Buy',

          If(Wildmatch(Code2,'DE7011*)','Sell',

               If(Code3="DE123" or Code3="DE124", 'New')))) as Titel

From ....;


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Create the field in the same load statement:

Load Date,

Code1,

Code2,

Code3,

If(Wildmatch(Code1,'T83400'),'Service') as Ser.A,

If(Wildmatch(Code1,'T83500'),'Buy') as Buy.A,

If(Wildmatch(Code2,'DE7011*'),'Sell') as Sell.A,

If(Code3="DE123" or Code3="DE124", 'New') as New.A,

If(Wildmatch(Code1,'T83400'),'Service',

     If(Wildmatch(Code1,'T83500'),'Buy',

          If(Wildmatch(Code2,'DE7011*)','Sell',

               If(Code3="DE123" or Code3="DE124", 'New')))) as Titel

From ....;


talk is cheap, supply exceeds demand