data loading from different source and set up from initial data

[dreweezy]

I currently have my qlik sense apps coming from a database that houses many tables and views. We will begin receiving much more data from a different source that has almost the same fields except the hierarchy is a bit different from the initial data load. 

As you can see, the initial data load is coming from 2 different tables. Now this new data coming in also has "ClientID" which makes sense to join on the 'Initial Data Load 2' column but I believe this is causing redundancy in the data. Wondering if anyone had a similar problem and what steps were taken to ensure data accuracy when bringing in a separate data source?

[JordyWegman]

Hi Dreweezy,

The current two initial data loads don't have any connections between them. But the new data load seems to connect both of them. Questions:

1. Initial Data load, is your Account unique?
2. Initial Data load 2, is your client ID unique?
3. New Data load, are both account and client ID unique?

Join the first and the new one together and link this based on ClientID.

Initial1:
Load
   *
From InitialDataLoad;

Left Join(Intial1)
Load
Account,
ClientID,
Cost of Goods
From NewDataLoad;

Initial2
Load
 *
From InitialDataLoad2;

Jordy

Climber