I want to compare the master file having the source location of three sheets (Chennai, Palani, Kakinada) in each of the sheets having destinations and columns having months I want to check the current month where I have an input Excel sheet having 3 columns (Source, Destination, FreightTon) I need to compare this with Master file first I want to check which source location and compare with master file and after that check the destination and then check the Current Month column if the value is less than or equal too then create a column name has result and write true otherwise false in the input file I want a code for this scenario for using UiPath.
this is the input file
here is the Master File Here its Mentioned LOC is the Destination
if any linq query or some other VB code also fine.
