hi all,
I have a list of tables (100 tables). need to load and concatenate all of them. the issue is some of the field names are dynamic. here are examples of two tables.. I need to concatenate the two tables and show Name, Category and then for the field starting with NS:AB I want to pick the one that has the highest digits in its name and bring that as "NSAB" Name.
My final table should have three columns:Name, Category, NSAB. the NSAB from each of the source table will be the field starting with the same name but has the highest digits next to it.
Table1:
Name,
Category,
NSAB12,
NSAB34;
Table2:
Name,
Category,
NSAB13,
NSAB56;
let me know if anyone can help.
