topic Re: Problems joining two resident tables in QlikView

Problems joining two resident tables

ecabanas — Wed, 23 Jan 2013 11:16:48 GMT

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

Re: Problems joining two resident tables

er_mohit — Wed, 23 Jan 2013 11:20:14 GMT

try

Tempdate:

Load *,DATEPHYSICAL as DATEFINANCIAL

resident INVENTTRANS;

Join (Tempdate)

Load *,DATEFINANCIAL

RESIDENT BBDD;

hope it helps

Re: Problems joining two resident tables

ecabanas — Wed, 23 Jan 2013 11:37:16 GMT

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

Re: Problems joining two resident tables

er_mohit — Wed, 23 Jan 2013 11:42:14 GMT

instead of using join

use concatenate(Tempdate)

hope it helps

Re: Problems joining two resident tables

Anonymous — Wed, 23 Jan 2013 11:43:23 GMT

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

Re: Problems joining two resident tables

jagan — Wed, 23 Jan 2013 11:49:57 GMT

HI,

Try this

Tempdate:

Load *,DATEPHYSICAL as DATEFINANCIAL

resident INVENTTRANS;

Join (Tempdate)

Load *

RESIDENT BBDD;

Hope this helps you.

Regarding,

Jagan.

Re: Problems joining two resident tables

ecabanas — Wed, 23 Jan 2013 12:41:30 GMT

tHANK'S iT WORKS!!!!

Re: Problems joining two resident tables

Anonymous — Wed, 23 Jan 2013 12:48:28 GMT

Anytime !

Re: Problems joining two resident tables

Wed, 23 Jan 2013 12:48:53 GMT

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