topic Re: Dynamically load fields from DB2 tables in QlikView

Dynamically load fields from DB2 tables

Wed, 02 Sep 2015 03:25:07 GMT

Hi guys,

I wonder if you can load dynamic fields from DB2 tables.

I'm connected to DB2 via ODBC connection, and I have loaded a table as:

NameTable:

TableName, FieldName

TableNameA, FieldName1

TableNameA, FieldName2

TableNameB, FieldName3

....

I need to load the value of all these fields from the corresponding tables, and left join to the NameTable, so I tried below code:

let vNOR=NoOfRows('NameTable');
for i=1 to $(vNOR)
let vTAB=FieldValue(TableName,$(i));
let vPK=FieldValue(FieldName,$(i));

trace $(vTAB);
trace $(vPK);

left join(NameTable)
load Distinct
TableName,
FieldName,
$(vPK) as PK_VALUE
from schema.$(vTAB);

But the code doesn't work. Can anyone help?

BR, PQ

Re: Dynamically load fields from DB2 tables

maxgro — Wed, 02 Sep 2015 19:08:10 GMT

try this

NameTable:

load * inline [

TableName, FieldName

TableNameA, FieldName1

TableNameA, FieldName2

TableNameA, FieldName3

TableNameB, FieldName4

TableNameB, FieldName5

];

load

TableName,

concat(FieldName, ', ') as Fields

Resident NameTable

Group By TableName;

for i=0 to NoOfRows('s')-1

t=Peek('TableName', i, 's');

s=Peek('Fields', i, 's');

set st='

left join (NameTable)

load *; '

& chr(10) &

'SQL select

$(s)

from $(t);'

;

//trace t=$(t);

//trace s=$(s);

trace st=$(st);

/* uncomment to execute

$(st);

NEXT i;