topic Join Two tables to form a Resident table in QlikView

Join Two tables to form a Resident table

Sat, 03 Dec 2011 10:33:47 GMT

Hi Experts,

I need to know whether we can join Two different tables to make a resident table.

For Eg:

Load

From Table1

Load

a1,

b1,

From Table 2

Then,

Load

a1,

resident Table1 join Table2

Can We do lik this??

Or Suggest me some method to make the same.

Thanks and Regards,

Gaayathri

Join Two tables to form a Resident table

swuehl — Sat, 03 Dec 2011 20:46:43 GMT

Hi,

not sure what you are after. Do you want a cross product? Or do you want to use some fields with common values to match? Maybe Fields c and c1?

Probably, if you could post some lines of mock up data for each table and then post your expected result, this would make thinks easier for us.

Regards,

Stefan

Join Two tables to form a Resident table

IAMDV — Sat, 03 Dec 2011 21:22:24 GMT

Hi Gaayathri,

Sorry, I am not very clear with your requirement. You can join two tables but is there any specific reason to use Resident Load instead of loading the tables? Like Stefan suggested... please explain in detail.

Thanks,

Join Two tables to form a Resident table

ToniKautto — Sat, 03 Dec 2011 21:52:02 GMT

Please keep in mind that when you join tables there most be common fields in the tables for a proper join to take place. In your example the table do not have have any common field, so you will end up with a lot of NULL values.

If you are new to QlikView a good idea can be that you load a very limited amount of your data (so that it is easy for you to validate the result) and try your joins to see if the result is as you expected. Read the manual sections on joins to get more details on the different kinds of joins, and find the one that suits your needs.

Join Two tables to form a Resident table

Sun, 04 Dec 2011 10:36:59 GMT

Hi,

Actually I need to show the Lost Customer,Exsisting Customer and New Customers and their sales over the years..

So I need to bring down the sales amount, Year info from Sales table and Customer name from the customer table and put it into a single table..

Thanks,

Gaayathri

Join Two tables to form a Resident table

swuehl — Sun, 04 Dec 2011 10:48:16 GMT

And both tables have a common field name, like CustomerID (or a field each that you indentify as common, but need to rename for QV to get the association right)? Could you post the fieldnames of your two tables with some words of explanation and maybe some lines of mock up data?