How to use wildcards in matching columns (Update Table)
Hi all,How can I update a table using wildcard? I already tried to create a column with a substring formuladt << New Column( "Code Ref", Formula (Substr(:Code, 1, 4)) );
TableACodeNameAgeABCD456Ann12ABCD123Roy16ABCD678Jean11 TableBCodeNameAgeABCD543John12FGR263Mike13ABCD975Rose8 After table update:CodeNameAgeABCD456Ann12ABCD123Roy16ABCD678Jean11ABCD543John12ABCD975Rose8 But I cannot use Code Ref as...