I have tow csvs parent and account. Both the csvs contains list of Accounts. The difference is that the parent.csv contains the list of all Accounts which will act as a parent account to others. Now for the question
The account.csv file contains two fields account name and parent name. THe parent name filed will be containing the values that are present in parent.csv.
How can I make sure that the tool will look up the GUID of the parent and insert it into the parent account field