Tables Keep Overwriting

[rwb139]

Hi all,

I am having trouble adding tables with the same name but different owners to my Qlik environment. For instance, I have owner1.accounts and owner2.accounts. When I load the first one, everything is fine, but then when I load the owner2.accounts it overwrites the ower1.accounts. I have tried changing the names of the tables before loading or adding the data to no avail. I  am also hesitant to move to the load editor and am using the data manager as I am new to coding and the like. Any suggestions would be greatly appreciated!

[Tanalex]

Do they have the same/similar structure?  If so, add NOCONCATENATE between the two LOAD commands and you will get two tables.  Qlik is likely combining them into one structure.

[rwb139]

They do have the same structure. I thought that Qlik might be combining them too, but I actually used a KPI to count the number of values in one of the tables and then when I loaded the second table, the number changes to the count of the second one.

[Tanalex]

If you want to reply with your load script, that may help answer this more specifically.

[rwb139]

@Tanalex 

Thanks for your help. Here is a zip of some screenshots that will hopefully provide more clarity.

[rwb139]

Here are two pictures of my KPIs. You can see how the numbers are reduced after loading my second table when it obviously should be increased if they were concatenating. Thanks again, @Tanalex !

[ArnadoSandoval]

Hi @rwb139 

It is a bit tricky to 'split' tables in the Data Manager, I haven't done it myself, but I give a try based in your problem, what I did was adding an Excel file into the DM, I got this:

The I added a second XL file (actually, I duplicated the first XL file, so I ended with two different objects with similar columns structure! here is the screenshot!

Please, check your Data Manager for something similar! Now if you hover your mouse over the panel with the x2, your will get a "hover menu" with to vertical lines; it will allow you to split those two tables!

the next screenshot shows the split tables !!!

Let me know if your Data Manager presents you with the same feature, I am using QlikSense Desktop November 2020!

Hope this helps,

[rwb139]

Hi @ArnadoSandoval 

That's very strange that yours is adding an not overwriting. I went back again and added both tables, and I don't have the "x2" next to my table. Here is a picture. Also I am a bit nervous to move to the data load editor as I am new to coding and the like and know that once I do, I can't go back to Data Manager. Would you suggest I make the move? And if so, do you have any suggestions for resources for me to learn it better? Thanks for everything! 

[ArnadoSandoval]

Hi @rwb139 

Sorry for the delayed reply, I had to install PostgreSQL and a sample database (dvdrental) to replicate your issue; the Qlik DM does not automatically concatenate tables with the same name from different owners; I suggest you add a view at one of the owners databases, the view something like this:

CREATE VIEW accounts_userX As SELECT * from accounts

This will allow qlik to concatenate these tables! The suggested view implement a SELECT all from the offending table.

I found another alternative, if you create a second Data Connection to the same database with a different name, as shown below, the DM separate both tables (you do not need the view in this case)

Hope this helps,