I was trying to write a function to join dt2 to dt1, however, I cannot get it to work at all... The error I got is "Name Unresolved: TrimTable at row 1 in access or evaluation of 'TrimTable' , TrimTable( dt1[1] ) /*###*/"
What is wrong?
Much appreciated for the help!
join_data_table = Function({dt1, dt2},
{Default Local},
dt_1 = TrimTable(dt1[1]);
dt_2 = TrimTable(dt2[1]);
dt_1 << Join(
With(dt_2),
Merge Same Name Columns,
By Matching Columns(:"Seq No"n = :Seq No),
Drop multiples(1, 0),
Include Nonmatches(1, 0),
Preserve main table order(1)
);
Return(dt1);
);