Hi, I have a table that is imported and the choices in several fields need to be converted. For instance
In my table, if the field name "SF Denial Reason" has a value of 001 Debt to Assets
The field "DB Denial Reason", in the same table, should populate with A20 .
I have a field mapping table that list all possible choices for "SF Denial Reason" and the corresponding "DB Denial Reason" values.
I need this auto-population to happen for several fields that all have different field mapping tables. If this was Excel, I would use a vlookup to accomplish this.
Enter VLOOKUP formula in Field 2 Table A:
In my table, if the field name "SF Denial Reason" has a value of 001 Debt to Assets
The field "DB Denial Reason", in the same table, should populate with A20 .
I have a field mapping table that list all possible choices for "SF Denial Reason" and the corresponding "DB Denial Reason" values.
I need this auto-population to happen for several fields that all have different field mapping tables. If this was Excel, I would use a vlookup to accomplish this.
Enter VLOOKUP formula in Field 2 Table A:
=VLOOKUP(Field 1 Table A, Table B, Table B Field 2)
Translation: Look in Field 1 Table B for value in Field 1 Table A
If found, update Field 2 Table A with corresponding value in Field 2 Table B
How can I get this to happen? Basically I have an imported file that has user-friendly values that I need to convert into database values so it can be exported to CSV and uploaded into a data warehouseTranslation: Look in Field 1 Table B for value in Field 1 Table A
If found, update Field 2 Table A with corresponding value in Field 2 Table B