Run part of a workflow in a loop based on a value of a column (in a loop)

[RadoslawCh]

I'm building a pdf report using Alteryx and am struggling to achieve the intended result, perhaps someone could advise as to how this could be achieved?

The data is structured in such a way (just for illustration, the data is in fact more complex)

Note: it is not know how many cities per person there could be

Person ID	Country	City	City index	Color
1	Poland	Warsaw	1	Yellow
2	Germany	Berlin	1	Red
2	Germany	Frankfurt	2	Blue
3	France	Paris	1	Black

The output will be a PDF for each person ID with a table for each City (title being the city name) , so if 2 cities per person than 2 tables one after another
e.g.

Person 1 it would be:

Title: Warsaw

Person ID	Color
1	Yellow

For Person 2 it would be:

Title: Berlin

Person ID	Color
2	Red

Title: Frankfurt

Person ID	Color
2	Blue

[alexnajm · Accepted solution]

Since you are saying PDF, I assume you are using the Reporting tools! In your Reporting tools (presumably a Table tool), you should just need to Group By the City and Person to get the individual tables, and then Layout the tables with some Report Text tools to create the headers

Can you attach a sample workflow showing your current logic?

[Raj · Accepted solution]

@RadoslawCh 
find the workflow attached
hope this helps.

[RadoslawCh]

Thank you for help guys, one final caveat thought: I need the layout column for each ID to be merged (so total 3 records, not 4) How can this be achieved?

[alexnajm]

One additional Layout tool to group on the Person ID and vertically orient your layouts will accomplish your final goal