Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have already created one qvd - TRADE. Now I have to create new qvd from other table and Qvd name - FTP
Now I have to update TRAD qvd on the basis of FTP qvd.
Logic:
CASE when(Trad.FTP_ENTITY_CODE IN ( select Trad_FTP_ENTITY_CODE from FTPLEMapQVD where Trad_LEGAL_ENTITY = 'HNAH') and (trade.FTP_AFFILIATE,'') NOT IN (select Trad_FTP_ENTITY_CODE from FTPLEMapQVD where Trad_LEGAL_ENTITY = 'HNAH'))
then 'Y'
else 'N'
end as Trad_IS_HNAH_FLAG.
how to use this logic by using two qvds. Please help me.
Thanks Vimlesh,
In my case I have 8 Cases so, I have to devide 4(FTP) and 4(Trade). Please suggest me
CASE when(trade.Trad_FTP_ENTITY_CODE IN ( select Trad_FTP_ENTITY_CODE from FTPLEMapQVD where Trad_LEGAL_ENTITY = 'HNAH') and (trade.Trad_FTP_AFFILIATE,'') NOT IN (select Trad_FTP_ENTITY_CODE from FTPLEMapQVD where Trad_LEGAL_ENTITY = 'HNAH'))
then 'Y'
else 'N'
end as Trad_IS_HNAH_FLAG,
CASE when(trade.Trad_FTP_ENTITY_CODE IN ( select Trad_FTP_ENTITY_CODE from FTPLEMapQVD where Trad_LEGAL_ENTITY = 'HUSI') and (trade.Trad_FTP_AFFILIATE,'') NOT IN (select Trad_FTP_ENTITY_CODE from FTPLEMapQVD where Trad_LEGAL_ENTITY = 'HUSI'))
then 'Y'
else 'N'
end as Trad_IS_HUSI_FLAG,
CASE when(trade.Trad_FTP_ENTITY_CODE IN ( select Trad_FTP_ENTITY_CODE from FTPLEMapQVD where Trad_LEGAL_ENTITY = 'HBUS') and (trade.Trad_FTP_AFFILIATE,'') NOT IN (select Trad_FTP_ENTITY_CODE from FTPLEMapQVD where Trad_LEGAL_ENTITY = 'HBUS'))
then 'Y'
else 'N'
end as Trad_IS_HBUS_FLAG,
CASE when(trade.FTP_ENTITY_CODE IN ( select Trad_FTP_ENTITY_CODE from FTPLEMapQVD where Trad_LEGAL_ENTITY = 'HBIO') and (trade.FTP_AFFILIATE,'') NOT IN (select Trad_FTP_ENTITY_CODE from FTPLEMapQVD where Trad_LEGAL_ENTITY = 'HBIO'))
then 'Y'
else 'N'
end as Trad_IS_HBIO_FLAG,
CASE when(trade.FTP_ENTITY_CODE IN ( select Trad_FTP_ENTITY_CODE from FTPLEMapQVD where Trad_LEGAL_ENTITY = 'HMUS') and (trade.FTP_AFFILIATE,'') NOT IN (select Trad_FTP_ENTITY_CODE from FTPLEMapQVD where Trad_LEGAL_ENTITY = 'HMUS'))
then 'Y'
else 'N'
end as Trad_IS_HMUS_FLAG,
CASE when(trade.FTP_ENTITY_CODE IN ( select Trad_FTP_ENTITY_CODE from FTPLEMapQVD where Trad_LEGAL_ENTITY = 'HBON') and (trade.FTP_AFFILIATE,'') NOT IN (select Trad_FTP_ENTITY_CODE from FTPLEMapQVD where Trad_LEGAL_ENTITY = 'HBON'))
then 'Y'
else 'N'
end as Trad_IS_HBON_FLAG,
CASE when(trade.FTP_ENTITY_CODE IN ( select Trad_FTP_ENTITY_CODE from FTPLEMapQVD where Trad_LEGAL_ENTITY = 'HNAH') and (trade.FTP_AFFILIATE,'') NOT IN (select Trad_FTP_ENTITY_CODE from FTPLEMapQVD where Trad_LEGAL_ENTITY = 'HNAH'))
then 'Y'
else 'N'
end as Trad_IS_HNAH_FLAG,
'Y' as Trad_IS_CONS_FLAG,