Problems joining two resident tables

[ecabanas]

Hi

I want to concatenate two tables, but I have  a problem with this:

Tempdate:

Load DATEPHYSICAL as DATEFINANCIAL

resident INVENTTRANS;

Left Join (Tempdate)

Load DATEFINANCIAL

RESIDENT BBDD;

Thank's

Eduard

[er_mohit]

try

Tempdate:

Load  *,DATEPHYSICAL as DATEFINANCIAL

resident INVENTTRANS;

Join (Tempdate)

Load *,DATEFINANCIAL

RESIDENT BBDD;

hope it helps

[ecabanas]

Hi

I have am error telling: "the fields names should be unique inside the table Join (Tempdate)

do you know what's wrong?

In the Inventtrans I have a list of dates, and in BBDD has another list of dates that could be the same from inventtrans, I would like to make a unique table wil all the dates

Thank's Er

[er_mohit]

instead of using join

use concatenate(Tempdate)

hope it helps

[Anonymous · Accepted solution]

I think you want to load two identical tables and concatenate them into one.

Try this :

Tempdate:

Load DATEPHYSICAL as DATEFINANCIAL

resident INVENTTRANS;

Load DATEFINANCIAL

RESIDENT BBDD;

QlikView will automatically concatenates tables with identical columns names.

The error in your statement was appearing because you were trying to add a second column with same name of the pervious one using LEFT JOIN.

I hope this helps!

MultiView

[jagan]

HI,

Try this

Tempdate:

Load  *,DATEPHYSICAL as DATEFINANCIAL

resident INVENTTRANS;

Join (Tempdate)

Load *

RESIDENT BBDD;

Hope this helps you.

Regarding,

Jagan.

[ecabanas]

tHANK'S iT WORKS!!!!

[Anonymous]

Anytime !

[#9]

Hi ecabanas,

Use:

Table1:

Load DATEPHYSICAL as DATEFINANCIAL

resident INVENTTRANS;

Load DATEFINANCIAL

RESIDENT BBDD;

Qlikview will perform auto concatenation,since the tables have columns ith identical names.

Or else,you have to mention the concatenate  statement,which forces concatenation with an existing named table or the latest previously created logical table.

Hope this helps,

Regards,

Snehal Nabar