Hi,
In qlik sense, I have connected two databases with multiple tables .But I can't identify the data for particular database.
In this i have mentioned database name field in each table .but,each table having one primary key. at that time each table having two same fields (ie. one is Primary key and another one Database name field ). So, its generate synthetic keys. But here, Database name field is not a primary key.
So Please help me, How to identify the data for particular database.
Note : each table having multiple databases data.