Need help on Identify the data for Multiple databases

[Ram83]

Hi,

 I have connected two databases. in each data base having same tables.

here, I have created the below structure

Table1:

Load

Key, ------> PrimaryKey

dbname, ---->dabase name

field1,

field2,....;

Select Key,dbname,field1,field2,.... from db1.A;

concatenate

select Key,dbname,field1,field2,.... from db2.A;

Table2 :

Load

Key, ------------->PrimaryKey

dbname,------>database name

field11,

field12,....;

Select Key,dbname,field11,field12,.... from db1.B;

concatenate

select Key,dbname,field11,field12,.... from db2.B;

while loading two tables its generate  synthetic keys Like.. Key+dbname

Actually Key is Primarykey , dbname is not a primarykey. It is identifying the data for particular database Purpose.

So please help me, How to create the database field in tables level or script level ?and Other wise without database name how to identify the data for particular database?

I am thinking, using database name we have to filter the data for particular database.

[Sue_Macaluso · Accepted solution]

@Ram83 Are you using QlikView or Sense?  I would like to move this into the correct product forum. 

[Ram83]

Hi,

  I am using Qlik Sense. Please forward this msg to Qlik Sense Forum.