topic Re: How to create one field using multiple fields from previous tables? in QlikView

How to create one field using multiple fields from previous tables?

Fri, 21 Apr 2017 02:23:35 GMT

I have a Table like

Load

From ....

By using A table, i am creating a new fields like P and Q. By using resident load

load *,

If(X=1,'True','False') as P,

if(Y=0,'True','False') as Q

Resident A;

Now i need to create another field like 'Z' help of A and B table fields( X, P, Q)..

How to create one field using multiple fields from previous tables?

Thanks for advance..

kaushiknsolanki — Fri, 21 Apr 2017 05:24:47 GMT

Hi,

I feel you need preceding load instead of resident.

Do something like this.

Load *,if(P=Q,1,0) as NewField;

Load *,

If(X=1,'True','False') as P,

if(Y=0,'True','False') as Q;

Load X,Y,Z from xyz;

Regards,

Kaushik Solanki