Group Loop / Loop Close problem

Greetings once again! Another issue with reporting from MOSAIQ in Oncology that I can’t seem to crack.

I have a report that pulls tumour markers (currently about 13 in total) status in cancers (e.g., PD-LI = 10%, ROS1 = normal). The report has a column called “Test” which contains the terms “PD-L1” and “ROS1”, a column to identify the patient, a column with the date of the test, and a column that provides the result (“10%”, “normal”). So a simple structure.

I want to write out all the PD-L1 data into a single Excel spreadsheet (“PD-L1.xlsx”) and all the ROS1 data into another Excel spreadsheet (“ROS1.xlsx”). I know that I can do that with 13 separate Row Splitter functions, but I can also do it with Group Loop Start/Loop End function.

Here is my current arrangement (there have been many previously!)

Group Loop Start selects “Test”.

String Manipulation (Variable) selects “string($${IcurrentIteration}$$)”.

Excel Writer has the path “P:\LungCancerMarkers\ + $${IcurrentIteration}$$ + .xlsx” and the created variable (none to choose) as IcurrentIteration.

While it runs, only one file is produced, so it’s obviously not working.

Apologies once again for being so inept, but can you help me please? Thanks in advance,

A