I'm currently trying to join two tables in an Excel file using JOIN statement with a wildcard.
PAD and Excel file are connected via ODBC Driver and typical SQL statements (like SELECT, JOIN, etc.) are running fine.
Test Data:
[TBL_1]
| COL_A | COL_B |
| foo | bar |
| aaa | bbb |
| ccc | ddd |
[TBL_2]
| COL_C | COL_D |
| xxx | abcfoodef |
| yyy | YYY |
| aaa | AAA |
[Expected Results]
| COL_A | COL_B | COL_C | COL_D |
| foo | bar | xxx | abcfoodef |
| aaa | bbb | | |
| ccc | ddd | | |
Using Execute SQL statement, I tried multiple ways but no luck, so far.
Following is some of the trial and error I did.
[Case A]
Error
[Case B]
Error
[Case C]
Error
[Case D]
Error
[Case E]
Error
I tried some more patterns but none of them worked, so far.
I think, the way I use the wild card '%' and 'LIKE' is the reason why it is getting the error but, could not figure out the right way.
Just to identify the issue, I also ran the following JOIN statement without a wildcard & LIKE and this ran fine.
Result
Would be great if anyone could provide me any help.
Thank you!
