I have a requirement to populate a new column in Alert table as ‘Alert Status ‘ by checking into Ticket tables which I have TicketwithL3Node and TicketwithL4Node both the tables have the same number (Name) of columns just don’t have value for ‘L4Node’ in TicketwithL3Node.
So if I do left join with Alert table and TicketwithL3Node it should be with Key L3Node
And if I do left join with Alert table and TicketwithL4Nodeit should be with Key L3Node&’|’& L4Node as Key
ifTicketType =’Performace’ then Alert Status should populate as ‘Ticket raised’
ifTicketType =Comment then Alert Status should populate as ‘No Action Required’
ifTicketType =Null() then Alert Status should populate as ‘No Action taken’
Tried- after doing left join separately for both the tables with Alert , concatenated the tables but it is not giving correct count of alert because of concatenation. ( Can’t Do distinct count as Alert number can be multiple)
Please advise if somebody worked with same type of problem.