Hi there. I am stuck at a task where I need to manipulate data table functions. However, I don’t know how the it could be done.
Currently, I have 2 data tables - which I call DT1 and DT2. Values in them are all strings.
DT1 is a list of numbers. DT2 consists of 3 columns, i.e. Number, Date, and Transaction Amount.
What I want to do is that for each row in DT1, find if there is the same number in DT2, and if there is, return the corresponding date and transaction amount to DT1, or create DT3 to store it. If the number could not be found in DT2, return “Not Found” in both columns (Date & Transaction Amount).
Please find the illustration below: