Hi all expert,
Kindly help, I have a data (sample attached).
I want to retrieve data from "table 1" to table 3. "table 2" is a table of changes to the data "account, CIF and Flag" in November 2018. example: CIF "ABC" there are changes to accounts and flags (the account changes to " 78910 "and the lost account is" 123, 456, 789 ". I want to fill in" table 3 "based on these changes where the lost accounts remain entered in" table 3 "and there is an" R "statement for the lost accounts from the data "table 1" in "table 3".
Thank you ,
Regard
dolphino
Bookmarks