I have 2 applications, data was migrated from App1 to App2. each app has a gui (front end) and a db(back end). I have the db mapping between the 2 applications and from that I need to find the Gui equivalent field names.
here I have App1 Gui names and their equivalent label in the db as shown below: (this would be column A and B in my spreadsheet)
Line no line-num
here is the App2. Gui names and their equivalent label : (this would be column F and G in my spreadsheet)
Line number data.dx
here is the mapping between the databases: (this would be columns K and L in my spreadsheet).
I need a formula that will find the Gui mapping between the 2 applications.
so the result should show me:
Line no Line number
Please specify the formula needs to be written in which cell?
Attached is my spreadsheet containing this information.