Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
sanket94
Contributor III
Contributor III

Running the sql in qliksense, I am unable to create insert and update(No delete) type of QVD

My Query is working as expected. I am trying to create a QVD that is insert and update ( No delete) Type of master QVD.

 

 

INTL_Allo:
select
trunc(PO.CREATED_DTTM)created_dttm,f.COUNTRY_CODE,ic.item_style SKU,max(IC.description) SKU_DESCRIPTION,CC.DESCRIPTION_SHORT US_HTS,tech_desc.tech_Desc technical_description
from
DOMP.PURCHASE_ORDERS PO
join DOMP.PURCHASE_ORDERS_LINE_ITEM POLI
on POLI.PURCHASE_ORDERS_ID=PO.PURCHASE_ORDERS_ID
join DOMP.ORDER_TYPE OT
on OT.ORDER_TYPE_ID=PO.ORDER_CATEGORY
join DOMP.PO_LINE_ITEM_REF_FIELDS r
on r.PURCHASE_ORDERS_LINE_ITEM_ID=POLI.PURCHASE_ORDERS_LINE_ITEM_ID
join WMSP.FACILITY_ALIAS FA
on FA.FACILITY_ALIAS_ID=PO.D_FACILITY_ALIAS_ID
join wmsp.facility f
on f.FACILITY_ID=FA.FACILITY_ID
and f.COUNTRY_CODE not in ('HK','US')
join WMSP.ITEM_CBO IC
on IC.ITEM_NAME=POLI.SKU
left join WMSP.COMMODITY_CODE CC
on CC.COMMODITY_CODE_ID=IC.COMMODITY_CODE_ID
left join (select style,HTS,MERCHCAT2,substr(listagg(upper(TEXTLINE),';')within group(order by SORTKEY),1,254)tech_desc
from
(select distinct style,hts,merchcat2,upper(textline)textline,sortkey
from WMSOPS.JC_HTSCODES
where hts is not null
and style is not null
and HTS not like 'N%'
and HTS not like 'E%')h
group by style,HTS,MERCHCAT2)TECH_DESC
on TECH_DESC.style=IC.ITEM_STYLE
and tech_desc.hts=cc.DESCRIPTION_SHORT
where 1=1
and po.created_dttm>=trunc(sysdate)
group by
trunc(PO.CREATED_DTTM),f.COUNTRY_CODE,ic.item_style,
CC.DESCRIPTION_SHORT, tech_desc.tech_Desc;

STORE INTL_Allo INTO [lib://Qliksense (pandhi)/IntlReport.QVD];

APPEND:

set ModificationTim=now();
set LastExecTime= ReloadTime();

SELECT SKU, COUNTRY_CODE FROM [lib://Qliksense (pandhi)/IntlReporsql.QVD]

WHERE ModificationTime >= $(LastExecTime);


Concatenate LOAD SKU, COUNTRY_CODY FROM IntlReporsql.QVD

WHERE NOT Exists(PrimaryKey);

 

STORE INTL_Allo INTO [lib://Qliksense (pandhi)/IntlReport.QVD;

 

image.pngimage.png

Labels (3)
0 Replies