topic Re: Two fields combine into one in script in QlikView

Two fields combine into one in script

Fri, 19 Aug 2011 19:14:56 GMT

My company has two Divisions. A Spa Division and a Bath Division.

I have two fields

[Field A] contains 'Spa' or 'Bath'

[Field B] conatins the identifier 'Both'

what is the eaiser way to get [field C] to contain all there

[Field C]

Spa

Bath

Both

Two fields combine into one in script

Fri, 19 Aug 2011 20:08:13 GMT

Two Questions, in your "field A", do you have blank spaces?or you have both fields A and B all filled?

Re: Two fields combine into one in script

nagaiank — Fri, 19 Aug 2011 23:10:09 GMT

The following script does this. There may be other ways of doing this.

Tab1:

LOAD Company,FieldB, If(FieldB='Both','Spa',FieldA) as FieldA,If(FieldB='Both','Bath') as FieldA1;

LOAD * Inline [

Company, FieldA, FieldB

C1,Spa,Both

C2,,Both

C3,Spa,

C4,Bath,

C5,Bath,Both

C6,,Both

];

Tab2:

NoConcatenate LOAD Company,FieldA as FieldC Resident Tab1 Where Len(FieldA) <> 0;

Concatenate LOAD Company, FieldB as FieldC Resident Tab1 Where Len(FieldB) <> 0;

Concatenate LOAD Company, FieldA1 as FieldC Resident Tab1 Where Len(FieldA1) <> 0;

Two fields combine into one in script

Fri, 19 Aug 2011 23:48:16 GMT

javortiz,

[Field A] doesn have an blanks. [Field A] is populated with either 'Spa' or 'Bath'

Two fields combine into one in script

tanelry — Sun, 21 Aug 2011 20:35:23 GMT

Teach users that selecting both values in field A already means "both"?

anyway, here you go...

// create new dimension table

LOAD * INLINE [

Field A, Field C

Spa, Spa

Bath, Bath

Spa, Both

Bath, Both

];

Two fields combine into one in script

Mon, 22 Aug 2011 03:39:36 GMT

Just use the field B only which contains both Spa and Bath. No need to merge both and create 3rd one.

Cheers.

Re: Two fields combine into one in script

Mon, 24 Jun 2013 11:35:18 GMT

Thank you, Your script help me to solve my issue.

Re: Two fields combine into one in script

Mon, 24 Jun 2013 11:41:13 GMT

Thank you, Your script help me to solve my issue.