Filter specific records with conditional statement.

[anonymous008_G]

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.

Sector	Fund OASD	Fund MV%	BM OASD	BM MV%	Main Flag
Quasi-Sovereigns	2.11	36.01	1.62	31.44	0
EMG	2.11	36.01	1.62	31.44	0
Corp HY	0.05	1.31	0	0	1
EMG	0.05	1.31	0	0	1
DEV	0.09	2.36	0	0	1
Sovereign Dev	1.97	32.01	1.52	28.5	0
EMG	1.97	32.01	1.52	28.5	0
Sovereign EM	0.09	2.69	0.09	2.94	0
EMG	0.09	2.69	0.09	2.94	0
Corp IG	2.36	51.36	2.36	40.21	1
EMG	2.36	51.36	2.36	40.21	1
DEV	1	3.32	0.26	1.25	1

[davidskaife · Accepted solution]

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 solution]

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

[anonymous008_G]

@Qiu @davidskaife  thank you both. both the solutions are good and solve my purpose. 

[stataltgee · Accepted solution]

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