concatenate load of tables with some fields names are dynamic
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.