1 Reply Latest reply: Jan 5, 2013 7:25 AM by steve peroni RSS

    How to assign a variable value to a new field during loading

    steve peroni

      Dear all,

      I've to gather the same information from several DB's. In order to avoid any kind of ambiguity, I would store the DB name into the final table.

      All the tables, are named as Mytabel + Dbname

       

      FOR i=0 to $(DATA_COUNT)-1

      let DBName=peek('NOME_DB',$(i),'mydblist');

      let nomedb = trim($(DBName));

       

      load .

      ..

      .. all the fields

      ...

      from

      Mytable$(DBName).qvd

      (qvd);

       

      What I'm trying is to add a new field like this:

       

      Load

      ...

      newfield containing the dbname

      from .....

       

      But without success. Is it possible to do it ?

       

      The final table should be like this:

       

      DBNAME     InvoiceNr.

      AAA               1

      AAA               2

      BBB               1

      BBB               2

      CCC               1

      CCC               2

      ...

       

       

      Help please

       

      Thanks in advance for your help