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

Natrah
Natrah New Altair Community Member
edited November 5 in Community Q&A
1st set data


2nd set data





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 :smile:

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  
Tagged:

Answers