Subtract values in one table from another

[maasool]

Hello

I have loaded in two tables. First table contains unique ITEMS and BALANCE for these items. Second table contains BOOKINGS related with certain ITEMS.  How to subtract bookings from related item balances in data load?

Table1:

ITEM
BALANCE

Table2:

ITEM
BOOKING

I would like to get Table 3:

Table3:

ITEM
BALANCE - BOOKING

[Vengatesh]

I don't know what are you trying to achieve here,

But in my guess Try this,

In table 3, Add Items as dimension and Sum(Balance)-Sum(Booking)

[maasool]

Thanks for the reply, but I would like to do the subtraction in data load not in app overview .

[Shubham_Deshmukh]

You need to join first 2 tables and then use resident load to do the requisite.
If possible share sample data or try above .