how to generate a column, wth attribute name "RESULT" that contain result "win" "lose" .

Natrah

New Altair Community Member

Oct 31, 2022

Updated Nov 5, 2024 by Jocelyn

1st set data

Image: https://us.v-cdn.net/6030995/uploads/editor/qf/44nkdfe25hab.png

Image: https://us.v-cdn.net/6030995/uploads/editor/po/kz29on69b0p8.png

2nd set data

Image: https://us.v-cdn.net/6030995/uploads/editor/qu/61f9eaxuse6p.png

Image: https://us.v-cdn.net/6030995/uploads/editor/dw/7stttgfpndac.png

i need help to combine this 2 set data and need to add new column that named as Result that label as Win or Lose

this win lose are determined by below scenario

the first set is the selected companies detail, in this table they will have attribute named mof_
no and qt_no which indicate they are the winner from a tender

the second data set show the overall involvement of companies with few detail. inside that data got loser and winner.

we have to get winner and loser and also result column

important thing : how to make sure the attribute all are filled and no nulls inside it