Discussion board where members can get started with QlikView.
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 nomedb = trim($(DBName));
.. all the fields
What I'm trying is to add a new field like this:
newfield containing the dbname
But without success. Is it possible to do it ?
The final table should be like this:
Thanks in advance for your help
Go to Solution.
perhaps I found the solution.
I tryed the following: '$(DBNAME)' as Newfield
It was necessary to put the variable into ' '
Thanks to everybody anyway