Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
alec1982
Specialist II
Specialist II

concatenate load of tables with some fields names are dynamic

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.

1 Reply
alec1982
Specialist II
Specialist II
Author

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