topic Re: Incremental load in QlikView

Incremental load

Sat, 03 Aug 2013 07:23:15 GMT

Hi All,

I use this script for incremental load but it give me SQL error any budy provide help for this specially SQL query.

[KONV]:

Load

[MANDT] as [Client_MANDT.KONV],

[KNUMV] as [Doc. condition_KNUMV.KONV],

[KSCHL] as [Condition type_KSCHL.KONV],

[MDFLG] as [Matrix maint._MDFLG.KONV],

[TXJLV] as [Jurisdiction level_TXJLV.KONV],

[KBFLAG] as [BitFlags_KBFLAG.KONV];

SQL Select KSCHL KOPOS KBETR KPEIN KMEIN KRECH KZBZG KUMZA KUMNE MWSK1 MWSK2 KONMS KONWS MANDT KNUMH KWERT KAWRT LIFNR KUNNR WAERS KAPPL KWAEH KNUMV KOUPD KSTBS ZAEHK STUNR KPOSN KOLNR VARCOND KDATU KSTAT KOAID STUFE WEGXX KKURS TXJLV SAKN1 SAKN2 KVSL1 KNTYP KINAK KNPRS KVSL2 KFAKTOR KRUEK KRELI KHERK KGRPE KDIFF KSTEU ZAEKO KMXAW KMXWR KDUPL KFAKTOR1 KAWRT_K KWERT_K KFKIV KVARC KMPRS PRSQU KTREL MDFLG KBFLAG from KONV

Where KNUMV in (Select KNUMV from VBRK Where ERDAT >= '20130801' and AEDAT >= '20130801');

For this query

Where KNUMV in (Select KNUMV from VBRK Where ERDAT >= '20130801' and AEDAT >= '20130801');

for VBRK table this query works fine but for KONV it gives me error

Thanks Ritul

Re: Incremental load

tresB — Sat, 03 Aug 2013 07:35:35 GMT

what is the error message?

Re: Incremental load

Sat, 03 Aug 2013 08:30:33 GMT

Hi,

Thanks please see the error message

/QTQVC/OPEN_STREAM failed after 00:00:00 Key = SQL_ERROR (ID:00 Type:E Number:001 Subqueries are only valid for transparent tables: "KONV".)

Where KNUMV in (Select * from VBRK Where ERDAT >= '20130801' and AEDAT >= '20130801')

Thanks Ritul

Re: Incremental load

Sat, 03 Aug 2013 09:31:58 GMT

Hi,

Did you found error message.

Thanks ritul

Re: Incremental load

Wed, 07 Aug 2013 12:01:51 GMT

Hi,

Any answer from you.

Thanks Ritul

Re: Incremental load

tresB — Wed, 07 Aug 2013 13:09:21 GMT

Hi,

your data source is SAP right? i am not much familiar with it. As the error message says, "Subqueries are only valid for transparent tables: "KONV" ", that means your in(select ...... part of code is not allowed for this table, because it is not a transparent table, while this works for VBRK table because it's a transparent table.

a bit of information i got here

Re: Incremental load

Thu, 08 Aug 2013 15:03:53 GMT

Hi,

Thanks for answer yes you are right let me suggest how to do this and also i have one problem for VBRK if i load data from the vbrk with where condition like

from VBRK

Where ERDAT >= '20130807' and AEDAT >= '20130807';

And hard code the date value then the script is loaded properly but i use the line of script like

from VBRK

Where ERDAT >= '$(vLastReload)' and AEDAT >= '$(vLastReload)';

it doesn't work i use the script to create the date variable like

Let vLastReload = Date(ReloadTime(),'YYYYMMDD') ;

Thanks

Re: Incremental load

Mon, 12 Aug 2013 07:01:32 GMT

Hi,

Please see this Thread and let me know how to do this it is urgent please.

http://community.qlik.com/message/377684#377684

Thanks