remove syn

Wed, 25 Nov 2020 16:16:04 GMT

hi,

i have two table; how can i remove syn,

thnks

ibrahim

SELECT yil YIL,

ay AY,

malzeme URUN_NO,

birim_maliyet BIRIM_MALIYET,

hammadde HAMMADDE_TUTAR,

direkt_isc DIREKT_ISCILIK_TUTAR,

amortisman AMORTISMAN_TUTAR,

end_isc ENDIREKT_ISCILIK_TUTAR,

enerji ENERJI_TUTAR,

gug GUG_TUTAR,

arindirilmis_smm SATILAN_MALIN_MALIYETI

FROM samet_maliyet_tablosu_tab

WHERE versiyon LIKE 'B%'

BUTCE_FIILI_SCRIPT:

LOAD

YIL,

AY,

MUSTERI_NO,

URUN_NO,

MIKTAR,

TUTAR_NET_TL,

TUTAR_NET_EUR,

TUTAR_NET_USD,

BIRIM_MALIYET,

TUTAR_BRUT_TL,

HAMMADDE_TUTAR,

DIREKT_ISCILIK_TUTAR,

ENDIREKT_ISCILIK_TUTAR,

AMORTISMAN_TUTAR,

ENERJI_TUTAR,

GUG_TUTAR,

SATILAN_MALIN_MALIYETI,

'Bütçe' as VERSIYON_Q

FROM \\10.1.1.105\c$\ProgramData\QlikTech\QlikDepo\BUTCE_TUM_YILLAR.qvd (qvd);

Re: remove syn

migueldelval — Thu, 23 Jun 2016 15:55:19 GMT

Hi Ibrahim,

You only need to change the name of fields who are repeating in both tables.

For example:

URUN_NO as URUN_NO_2,

Or don´t load repeated fields in one table.

Remember that 1 field it´s necesary to be in both tables.

Regards

Miguel del Valle

Re: remove syn

Gysbert_Wassenaar — Thu, 23 Jun 2016 15:59:58 GMT

Perhaps you should simple concatentate the two tables instead of joining them.

topic Re: remove syn in QlikView

remove syn

Re: remove syn

Re: remove syn