Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
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
Perhaps you should simple concatentate the two tables instead of joining them.