Filter specific records with conditional statement.

Question

Hi,

I need help with my attached workflow. I have already flagged Corp HY and Corp IG records using the formula tool. However, I also need to flag EMG and DEV records, which come immediately following Corp HY and Corp IG. Can someone please help further using the attached workflow? How would I flag EMG and DEV records using the multi-row formula tool?
Expected output should like this.

SectorFund OASDFund MV%BM OASDBM MV%Main FlagQuasi-Sovereigns2.1136.011.6231.440EMG2.1136.011.6231.440Corp HY0.051.31001EMG0.051.31001DEV0.092.36001Sovereign Dev1.9732.011.5228.50EMG1.9732.011.5228.50Sovereign EM0.092.690.092.940EMG0.092.690.092.940Corp IG2.3651.362.3640.211EMG2.3651.362.3640.211DEV13.320.261.251

Sample flow.yxmd

davidskaife · Accepted Answer

Hi @anonymous008_G

Here you go, simply update the Flag_Main field using this formula:

IF [Row-1:Flag_Main] = '1' AND [Sector] IN ('EMG','DEV')
THEN 1
ELSE [Flag_Main]
ENDIF

Qiu · Accepted Answer

@anonymous008_G 
How about we use one Multi-row formula tool instead the normal formula tool?

unknown · Accepted Answer

@anonymous008_G  Just add a multirow tool before formula tool and then modify the formula tool.