How to subtract values from two data tables with same columns?

Hi frds

I have one excel like dis:


First I want to check if dt1(location) contains dt2(location) and if it does i have to subtract the cols as shown in d pic

i have tried using fr loop but since we cannot use column names since it may keep varying its bit diffcult for me… i’m beginner

pls guide me :pray: @ppr @Lahiru.Fernando @Palaniyappan

@Anthony_Humphries can u take a look at dis too?

Interesting problem. Attached solution: (10,2 Ko)

I did not understand this solution, Can you please elaborate.

What is the solution to this? I am facing similar issue.