Hi @Jean-Balteryx ,
Thank you for helping out on 2nd question.
for the first question, I have two tables i.e. table A and table B
In table A, Unclassified and Not Valid fields are region and Number, so whenever I get Unclassified or Not Valid in any of the field then it should check from Table B, for an instance here, table B contains fields region code, region name and number.
If US is present in Table B, then it should return US instead of Unclassified/Not Valid. so, in output if the data is present but still showing Unclassified then it should give the output along with field 'Company Name'. In the output file I need which value is present in the campaign field. Table C is the output file.
If you see the Table A, field name 'Company Name' is delimiter with underscore (_)
1st position- Company- ABC
2nd position- Client- Safo
4th position- region- Unclassified
6th position- number- 1 and Not Valid