dynamic association field to report

[#1]

Hello ,

i have a question :

i have a qlik document with same object to do report / analysis on more db.

these db have the same table .

It's work fine , when i connect to db1 or db2 the object work.

But there are several table with different field

EXEMPLE:

db1

t_export

idlog

name

surname

city

db2

t_export

idlog

tel

cel

name

I want create a table box (or other that can do this) with dynamic association of the field of the table t_export . The field have to show in the same order that i have in the table:

if i connect to db1 i want my object with the field :

idlog

name

surname

city

if i connect to db2 i want my object with the field :

idlog

name

surname

city

I don't want that the people that use my document have to associate manualy the field to the object.

I want that this object is populate automatically with the field , in the order of my table.

How i can do this?

Bye

Walter

[Gysbert_Wassenaar]

for db1 do:

LET vDB = 1;

LOAD

t_export

idlog

name as F1

surname as F2

city as F3;

select ....;

for db2 do:

LET vDB = 2;

LOAD

t_export

idlog

tel as F1

cel as F2

name as F3;

select ....;

Then in your table box add all the fields and set the label of F1 with an expression: =pick($(vBD),'name','tel'). Same for F2 and F3 with their respective labels.

[#3]

Hello ,

thank you for your answer. that's right!!!

But i have a problem:

in my exemple i have only 2 db , but instead i have more db (50-100 db) also the table t_export have different number of fields: in same case 10 fields in other case 50 , in other case 100 or more.

Do you have an idea for this ?

Thanks

Walter