topic Re: Create New Field Using Existing Field in QlikView

Create New Field Using Existing Field

Anonymous — Wed, 16 Jul 2014 13:00:23 GMT

Hi,

I have a field 'Source' which has values - A, B, C, D, E.

I want to create a new field using this 'Source 1' that should have all the values except A.

How can I create this new field?

Re: Create New Field Using Existing Field

alexandros17 — Wed, 16 Jul 2014 13:02:31 GMT

Load

....

if(Source<>'A', Source, 'To be defined') as Source

...

Let me know

Re: Create New Field Using Existing Field

simenkg — Wed, 16 Jul 2014 13:02:43 GMT

if(Source=A,null(),Source) as Source 1

Re: Create New Field Using Existing Field

puttemans — Wed, 16 Jul 2014 13:06:44 GMT

Hi,

Think it should rather be

if(Source<>'A', Source,'-') as Source_1

As you do not want to replace the Source variable, but create a new one.

Re: Create New Field Using Existing Field

Wed, 16 Jul 2014 13:09:55 GMT

if(Source<>'A',Source)

Re: Create New Field Using Existing Field

alexandros17 — Wed, 16 Jul 2014 13:10:50 GMT

I have written 'To be defined' because Rahul did not say what to do with missing values ... they could be set to Null(), blank or something else

Re: Create New Field Using Existing Field

puttemans — Wed, 16 Jul 2014 13:15:19 GMT

No issue there, that's indeed whatever you like. I think you may have forgotten to add the correct variable you want to write the information to. The basis is Source, but an additional variable should be created Source 1. In your formula, you tend to overwrite Source, Hence my reaction.

Re: Create New Field Using Existing Field

Anonymous — Wed, 16 Jul 2014 13:19:24 GMT

Thank you for all your suggestions. It worked!

Regards,

Rahul

Re: Create New Field Using Existing Field

Wed, 16 Jul 2014 14:29:21 GMT

Hai Rahul,

Could you please post the screen shot of code for creating new field from existing .

Thank you

Re: Create New Field Using Existing Field

Anonymous — Wed, 16 Jul 2014 14:32:35 GMT

Re: Create New Field Using Existing Field

Wed, 16 Jul 2014 15:57:16 GMT

Thank you Rahul