I have two values like x from A table and y from B table.
I want to create a Table by taking difference of x an y.
assuming there is a common field you can define:
left join (tmptest)
x-y as diff
drop table tmptest
hope that helps
Getting error after resident A. not able to use left join.
PremiumOGIS Resident OGIS
Try like this
left join (Temp)
drop table Temp
Hope this helps you.
This can be possible with Resident load, please see below yon do something like that :
Resident load is like this.
select columna, value, columnb
select columna, sum(value)
group by columna;
please post sample data of both tables
I suggest to make a mpaping from one table and then use an applymap to the sencond.
Mapping Load key,
(applymap('Map_Table',key,Null()) - y) as Diference
Retrieving data ...