topic To Load Field Values into a variable How? in QlikView

To Load Field Values into a variable How?

narayanaqlik — Tue, 21 Aug 2018 11:02:11 GMT

Hi All,

I have taken DB tableNames and required fields in Excel by creating Fields 'DBTables" ,"RequiredFields"

here I want to load all Required Fields into one variable how

DB Table, Status, Required Field

ABC, Yes, abcers

ABC, yes, cbbge

ABC Yes nbc

CBA yes BNH

CBA yes CVB

CBA Yes GHJ

CBA Yes RTY ....

I have loaded entire Excel

so here i have filter it out where DB Table='ABC' and Status='YES' so all the fields related ABC will come

Here all the values in "Required Field" need to load into a variable How?

Could you any plz help..

No I have tried that

let vTableColoumns=Concat( Distinct 'RequiredFields');

it is pickuping any values just zero only

Thanks..

pradosh_thakur — Tue, 21 Aug 2018 11:08:39 GMT

=concat( distinct RequiredFields) or =concat( distinct {1} RequiredFields) may be

marcus_sommer — Tue, 21 Aug 2018 12:11:40 GMT

You need to use concat within a load and then using peek() to grab this value from there, maybe in this way:

load [DB Table], concat([Required Field], ', ') as FieldList

from Excel group by [DB Table] where DB Table='ABC' and Status='YES'

let v = 'select ' & peek('FieldList', 0, 't') & ' from ' & peek('DB Table', 0, 't') & ';';

and then maybe:

$(v);

- Marcus