Update a table with another table based on "Nearest Match" columns
Hello, I have 2 tables (Table1 and Table2), both queried from databases.I need to update Table1 with Table2 by matching columns (:match). The problem is: - I get :match content for Table1 with a Regex from the database with (sometimes) this format: “XXXX-YY-ZZZ”.- I get :match content for Table2 from another database with a different but consistent format: “XXXXYYZZZ”. I can manually use If() and ...