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

Help Studio
1

Hi frds

I have one excel like dis:

image

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

2

@Anthony_Humphries can u take a look at dis too?

3

Interesting problem. Attached solution:

Processusvierge.zip (10,2 Ko)

1 Like
4

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

5

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