I am trying to add the column PO_line_number (in red) into the second table.
Problems: In the second table, the column Description Invoice-Voucher has the invoice-voucher number in the description. It not a 100% matching Field. The Product numbers are very close to each other (one character different)
What I have tried:
- After isolation the maximum the invoice voucher from the description field - I am using a concatenation: Product_number&Invoice_Voucher. - I have tried to use the fuzzy merge function, the problematic is related to the product number. The system get the right invoice with the wrong product.
Table.FuzzyNestedJoin(table1 as table, key1 as any, table2 as table, key2 as any, newColumnName as text, optional joinKind as nullable number, optional joinOptions as nullable record) as table
What I would try:
For each row from the second table, 1) read the product number 2) filter the first table 3) Fuzzy merge the filter table