Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@Ram83 Are you using QlikView or Sense? I would like to move this into the correct product forum.
@Ram83 Are you using QlikView or Sense? I would like to move this into the correct product forum.
Hi,
I am using Qlik Sense. Please forward this msg to Qlik Sense Forum.