remove syn

[#1]

hi,

i have two table; how can i remove syn,

thnks

ibrahim

1

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%'

2

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);

[migueldelval]

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

[Gysbert_Wassenaar]

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