Concatenate problem

[#1]

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

[#2]

Hi Elad,

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

Regards, Roland

[#3]

Hello Roland,

can you explain?

Elad

[#4 · Accepted solution]

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.

RR

[#5]

Roland,

WOW,

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

Thank you very much

Have a great day

Elad

[suniljain]

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

thanx to qliktech