Join Two tables to form a Resident table

[#1]

Hi Experts,

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

For Eg:

Load

a,

b,

c

From Table1

Load

a1,

b1,

c1

From Table 2

Then,

Load

a,

b,

a1,

b1

resident Table1 join Table2

Can We do lik this??

Or Suggest me some method to make the same.

Thanks and Regards,

Gaayathri

[swuehl]

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

[IAMDV]

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,

DV

[ToniKautto]

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.

[#5]

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

[swuehl]

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?