Hello,
I am trying to acheive this function;
- I have table of Budget line connected to a Unique product ID and to invoice associated
| Buget_Request_number | Budget_Item_Number | Invoice-Voucher | Product_Number | Unique Budget line |
| BR90788653 | 1 | 8909878 | 45WR7890 | Budget_Request_number&Budget_Item_Number&Product_Number |
- I have a Table of payment linked to the Unique product ID.
| Description Invoice-Voucher | Product_Number | (Does not exist yet in this table) PO_line_number |
| Payment 8909878 | 45WR7890 | Buget_Request_number&Budget_Item_Number&Product_Number |
What I am trying to acheive:
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
Any idea on how to solve this?
