topic Re: From Script - Add new field according to values in another field in QlikView

From Script - Add new field according to values in another field

Sun, 23 Jun 2013 12:04:46 GMT

Hello All

I have a field named

"Summary_Text"

with data as follow

[SP] - Factory 4545

[BF] - Error during Loadin

[IN] - Installation start fine

I need to create a new Field "Charge_Type" according to the text I have into the Bracket

[SP] ==> will be Site_prep

[BF] ==> will be Brake_Fix

[IN] ==> will be Installation

Thanks

Franck

Re: From Script - Add new field according to values in another field

ariel_klien — Sun, 23 Jun 2013 12:21:20 GMT

Hi,

Try:

LOAD if(TextBetween(SUMMARY_TEXT,'[',']')='SP','Site_prep',

if(TextBetween(SUMMARY_TEXT,'[',']')='BF','Brake_Fix',

if(TextBetween(SUMMARY_TEXT,'[',']')='IN','Installation'))) as Charge_Type;

SELECT SUMMARY_TEXT

from ....

Ariel

Re: From Script - Add new field according to values in another field

swuehl — Sun, 23 Jun 2013 12:24:26 GMT

Try a mapping of your field values, like this:

TextMap:

MAPPING LOAD * INLINE [

Abb, Type

SP, Site_prep

BF, Brake_Fix

IN, Installation

];

LOAD

Summary_Text,

ApplyMap('TextMap', TextBetween(Summary_Text,'[',']') ) as Charge_Type,

...

FROM ...;

Re: From Script - Add new field according to values in another field

ariel_klien — Sun, 23 Jun 2013 12:29:50 GMT

better then my suggestion....

Re: From Script - Add new field according to values in another field

Sun, 23 Jun 2013 12:31:05 GMT

Thanks To you , Ariel and Swuel

I am trying it

Re: From Script - Add new field according to values in another field

Sun, 23 Jun 2013 13:09:19 GMT

Again thanks

Both way working, I learned from both of you .

BIG THANK