Marge SAP tables

[#1]

Hello,

I download VBRK table from our SAP system and keeps it in QVD file

Every day I download VBRK delta from our SAP system and saves them in another QVD file.

I want to save the second QVD file into the first one and to make VBELN field ad a key.

I will be happy to help - How do I write the script.

Thank you

Elad

[suniljain]

I implemented Following scenarion for increamenta load of SAP Table Scenario:

load

*

From Todays_VBRP

concatinate

load *

From Historical_VBRN

where VBELN Not exist.

[#3]

Hello Sunil,

Thank you for your answer.

i tried to implment this script.

VBRK:

load

* From \\DEV\VBRK_DELTA.QVD (QVD)

;

Concatenate

load

* From \\DEV\VBRK.QVD (QVD) where (VBELN) not exist;

store

* from VBRK into \\DEV\VBRK_ALL.QVD;

And I recived this error message "Garbage after statement
Concatenate"

Thank you again

Elad

[etay_netintent]

Hello

In order to do incremental loads from/into QVD you do need to use the concatenate keyword.

Qlikview will append 2 tables with the same structure automatically.

In order to avoid overlap between the two files you need to use the NOT EXISTS(Field, Field).

Unlike exists you can not use the same field name in the exist.

If your field is names Key the load should look something like this:

Table:

LOAD X, Y, Key, Key as Key1;

Select X. Y. key

FROM SAP;

LOAD X, Y, Key , 0 as Key1

FROM OLD.qvd (qvd)

WHERE NOT EXISTS (Key, Key1);

DROP FIELD Key1;

STORE * FROM Table into OLD.qvd;

I hope I haven't confused you even more....

Etay Elazar

[Miguel_Angel_Baeyens]

Hello Elad,

Use the where statement as follows

LOAD* From \\DEV\VBRK.QVD (QVD) where NOT EXISTS(VBELN);

Meaning will be loaded only VBELN values not already retrieved by the previous LOAD.

Hope that helps

[suniljain]

Dear Elad,

Are you get delta load solution of SAP R/3 ?.

Regards

Sunil