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 · Accepted solution]

Hi @tanvir_khan — Try this solution:

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

[vizAlter]

@tanvir_khan — Also, you may optimize the workflow by keeping the specific tools, like below:

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