concatenate load of tables with some fields names are dynamic

[alec1982]

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.

[alec1982]

moving this post to the top to get anyone to help.