flag

[subbareddykm]

Hi all

i want to create flag like

if D.no has Staus= H , S and Tx is same for Both H,S and if rank is same , How can i acheive this in backend ?

[subbareddykm]

Hi , Can any one tell me how to achieve this ?

[MarcoWedel]

Please post example values and expected flag results.

Regards

Marco

[subbareddykm]

[swuehl]

Maybe like this?

TMP:
LEFT JOIN (Sheet1$)
LOAD D.No, StausFlag*TxFlag*RankFlag as Flag;
LOAD D.No,
  If( Count(DISTINCT If(Match(Staus,'H','S'), Staus))=2, 1,0) as StausFlag,
  IF( Only(If(Staus= 'H',Tx))=Only(If(Staus='S',Tx)), 1,0) as TxFlag,
  IF( Only(If(Staus= 'H',rank))=Only(If(Staus='S',rank)), 1,0) as RankFlag
Resident Sheet1$
GROUP BY D.No;