topic Re: Multiplication with Multiple fields in load Script. in QlikView

Multiplication with Multiple fields in load Script.

renuka_sasikumar — Tue, 23 Jun 2015 12:31:32 GMT

Hi,

Table A	Table B
AccCode	AccCode
Computaion	AB_History_AB_consumed,
AccOpn	AB_DEL,
AB_ID,
AB_Fut,
AB_Opt,
AB_History_AB_CDS,
AB_CDS_OPT,
AB_Excess
xyz
abc

I have joined Table A & B

Now I want the Fields

eg: AB_DEL,

AB_ID

...

....

to multiply by computation

Can you help me with syntax to get this output

Thanks & Regards,

Renuka S

Re: Multiplication with Multiple fields in load Script.

sunny_talwar — Tue, 23 Jun 2015 12:43:28 GMT

Now I want the Fields

eg: AB_DEL,

AB_ID

...

....

to multiply by computation

What do you mean by the last line above, are you trying to get AB_DEL * computation and AB_ID * computation???

Re: Multiplication with Multiple fields in load Script.

renuka_sasikumar — Tue, 23 Jun 2015 13:02:15 GMT

Yes I want the same to be done

Re: Multiplication with Multiple fields in load Script.

sunny_talwar — Tue, 23 Jun 2015 13:07:23 GMT

Have you tried this:

TableA:

LOAD AccCode,

Computaion,

AccOpn,

AB_ID,

AB_Fut,

AB_Opt,

AB_History_AB_CDS,

AB_CDS_OPT,

AB_Excess,

xyz,

abc

FROM Source1;

Join (TableA)

LOAD AccCode,

AB_History_AB_consumed,

AB_DEL

FROM Source2;

FinalTable:

LOAD *,

AB_DEL * Computation as NewField1,

AB_ID * Computation as NewField2,

...

Resident TableA;

DROP Table TableA;

Re: Multiplication with Multiple fields in load Script.

renuka_sasikumar — Tue, 23 Jun 2015 13:07:48 GMT

Hi,

Can I write like this

AB_DEL as AB_DEL_OR,

if(AB_DEL>0, Num(AB_DEL)*Num(Computation)) as AB_DEL,

AB_ID as AB_ID_OR,

if(AB_ID>0, Num(AB_ID)*Num(Computation)) as AB_ID,

Is this a correct a way...Can I use it.

Thanks & Regards,

Renuka S

Re: Multiplication with Multiple fields in load Script.

giakoum — Tue, 23 Jun 2015 13:08:09 GMT

load

AB_DEL * computation as ABDelMultiplied,

AB_ID * computation as ABIDMultiplied

....

resident yourTable

etc.

Is this what you are asking?

Re: Multiplication with Multiple fields in load Script.

giakoum — Tue, 23 Jun 2015 13:09:19 GMT

try it

but note that num is a format function. If you need to change the field type, use Num#

Re: Multiplication with Multiple fields in load Script.

sunny_talwar — Tue, 23 Jun 2015 13:09:26 GMT

Absolutely, I don't see anything wrong with what you just showed. Do you get any error when you run it?

Re: Multiplication with Multiple fields in load Script.

renuka_sasikumar — Tue, 23 Jun 2015 13:28:52 GMT

No I am not getting any error.

I think its working.

But hope there should be no problem in rest of Data.

Thank you everyone for your prompt reply.

Thanks & Regards,

Renuka S

Re: Multiplication with Multiple fields in load Script.

sunny_talwar — Tue, 23 Jun 2015 13:30:07 GMT

Yup, you can always come back when you see discrepancies in the results you are seeing.

Best,

Sunny