topic Re: Insert dynamic value into my load table in QlikView

Insert dynamic value into my load table

Fri, 25 Jul 2014 08:29:01 GMT

Hello everyboqy i met an problem,

I explain, i ve an 'extract script" wich extract for every society an FACT table but the information of the society is not into the FACT table and i woul like to add this informatio into all my society FACT table .....

For that, I try to put into an new field "Society" an dynamic value but it doesn't work and i don t know how to do...

For the moment, I use an

SET ListeSte={‘name_society1’, ‘name_society2’,etc….}

FOR each SteEnCours in $(ListeSte)
trace ----------------------------$(SteEnCours)-------------------------------------; //$(SteEnCours)
ODBC CONNECT32 TO $(SteEnCours);

Table_FACT :

LOAD

$(SteEnCours) as Society,

Field1,

Field2,

Field3,

Etc…

From

SQL SELECT....

etcC….

STORE Table_FACT into " .........\$(SteEnCours)_Table_FACT .qvd";

DROP TABLE Table_FACT ;

But the problem with this code the value of society is not the name_society1,2,etc...

For each society table fact the value of the field is = '$(SteEnCours)''

Do you have any idea how to put an value dynamic into my table....

Thanks

Pierre

Re: Insert dynamic value into my load table

Fri, 25 Jul 2014 09:23:18 GMT

Hi Pierre,

Use quotes for the variable in LOAD '$(SteEnCours)' as Society,

SET ListeSte=‘name_society1’, ‘name_society2’;

FOR each SteEnCours in $(ListeSte)
trace ----------------------------$(SteEnCours)-------------------------------------; //$(SteEnCours)
ODBC CONNECT32 TO $(SteEnCours);

Table_FACT :

LOAD

'$(SteEnCours)' as Society,

Field1,

Field2,

Field3,

Etc…

From

SQL SELECT....

etcC….

STORE Table_FACT into " .........\$(SteEnCours)_Table_FACT .qvd";

DROP TABLE Table_FACT ;

Re: Insert dynamic value into my load table

Sun, 27 Jul 2014 23:55:32 GMT

Hi, You can pass the variable value into field name as well.

Please use the below script:

SET ListeSte={‘name_society1’, ‘name_society2’,etc….}

FOR each SteEnCours in $(ListeSte)
trace ----------------------------$(SteEnCours)-------------------------------------;//$(SteEnCours)
ODBC CONNECT32 TO $(SteEnCours);

Table_FACT :

LOAD

'$(SteEnCours)' as [$(ListeSte)],

Field1,

Field2,

Field3,

Etc…

From

SQL SELECT....

etcC….

STORE Table_FACT into " .........\$(SteEnCours)_Table_FACT .qvd";

DROP TABLE Table_FACT ;