I have two tables, table A and Table B. In table A, I am getting Unclassified so I want to get the data from Table B i.e. instead of Unclassified I should get US and when it is United States it should return United States.
Hi @Parth5 ,
About your first question, I don't get what you need, could you produce a desired output file ?
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.
Why, in the output, is the values for "number" column null for first two rows then 2 for other rows ?
Because number '1' is already present in table A, we want the values which are Unclassified and Not Valid
Then why 2 and not 3 ?
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
Ok, so should "region" and "number" be taken from that name if Unclassified/Not Valid ?
Be cause in your output example, everything is US while there are some UK values in names.