This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email firstname.lastname@example.org for assistance.
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.
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.