Incremental load

[#1]

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

[tresesco]

what is the error message?

[#3]

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".)

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 * from VBRK Where ERDAT >= '20130801' and AEDAT >= '20130801')

Thanks Ritul

[#4]

Hi,

Did you found error message.

Thanks ritul

[#5]

Hi,

Any answer from you.

Thanks Ritul

[tresesco]

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

[#7]

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

[#8]

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