topic Concatenate problem in QlikView

Concatenate problem

Wed, 01 Dec 2010 13:07:29 GMT

Hello,

I try to concatenate between this 2 tables:

ZVBAK_KONV_1

ZVBAK_KONV_2

With this script:

VBAK_KONV:

load *,

VBELN&'-'&KPOSN&'-'&KNUMV&'-'&STUNR&'-'&KSCHL As key

From \\01122010\ZVBAK_KONV_1.QVD (QVD);

Concatenate

load * ,

'-' as Key

From \\01122010\ZVBAK_KONV_2.QVD (QVD) where NOT EXISTS(Key,VBELN&'-'&KPOSN&'-'&KNUMV&'-'&STUNR&'-'&KSCHL);

drop field Key;

store * from VBAK_KONV into "\\01122010\ZVBAK_KONV_3.QVD";

DROP TABLE VBAK_KONV;

For some reasons the records from first table added to the records from the second table Without regard to key field.

Thank you in advance for your help

Elad

Concatenate problem

Wed, 01 Dec 2010 13:18:04 GMT

Hi Elad,

take a look at your spelling of key and Key! Any Idea ? ;-))

Regards, Roland

Concatenate problem

Wed, 01 Dec 2010 13:47:40 GMT

Hello Roland,

can you explain?

Elad

Concatenate problem

Wed, 01 Dec 2010 14:30:34 GMT

Hello Elad,

one of your fields is called key and the other one did you name Key. These are in fact two different fields because fieldnames in a script are case sensitive. Even key and keY are two different field(name)s.

Concatenate problem

Wed, 01 Dec 2010 15:20:28 GMT

Roland,

WOW,

So simple and I worked to solved this somthink like 4 hours,

Thank you very much

Have a great day

Elad

Concatenate problem

suniljain — Fri, 07 Oct 2011 11:09:43 GMT

in qlikview sap connector 5.6 . this task become easy.you can use sub query with cluster table.

thanx to qliktech