Join two datasets with custom key

tanvir_khan

Hi

I need to join two datasets but there is no straightforward join key.
example TABLE1.SCode = SUBSTR(TABLE2.FCode, 1, TABLE1.Length)

Table1

SCode|Length

561|3

78|2

6537|4

Table2

FCode|Name

561298|AAATR

23412|BBBAV

7892|ZZZA

653721|CCCA

The substring will match FCode of Table2 with SCode of Table1 as per length given in Table1. 
Need your expert advice to resolve it using alteryxplease.

thanks

vizAlter

Hi @tanvir_khan — Try this solution:

If this solves your issue please mark the answer "Solved" with a Like, if not let me know!

Join two datasets with custom key.yxmd