how to add columns from two tables

[#1]

Hi Friends

I have two tables A and B like

A                B

pvalueA        pvalueB

qvalueA         qvalueB

rvalueA         rvalueB

Now I need to write script to add pvalueA+pvalueB as say Z. I want to do at the script level not at the front end.

Thanks

[ali_hijazi]

A:

Load A

B:

load B

join(A)

load * resident B;

drop table B;

tempA:

load A,B, A&B as Z

Resident A;

drop table A;

rename table tempA to A;

[#3]

A:

load A
B:

load B

noconcatenate

C:

load

pvalueA

resident a;

concatenate

load

pvalueB

resident b;

LOAD

PVALUEA+PVALUEB AS Z

RESIDENT C;

[Anonymous · Accepted solution]

Hi Pawan,

Find below example which adding the values of two columns.

Let me know if you are looking for the same or anything else.