Creating a table with static and variable fields

[kas]

Hello,

Hope there is a relatively simple solution I'm just not wrapping my head around.

I have a set of data (attached), that I need to use to populate a table. The part I'm not putting together is that there are static fields in the table that aren't in the data set, but, I need to base on how to fill in the variable fields with data based on some of the static fields (example: if [Premium Frequency] = 'Annual' then [Annual PP] elseif [Premium Frequency] = 'Semi-Annual' then [SAPP] elseif [Premium Frequency] = 'Quarterly' then [QPP] elseif [Premium Frequency] = 'Monthly' then [MPP] else ' ' endif). Each line of data needs to have its own table. Image of the table attached as well as a text tool with the table laid out. In the table, anything in black is static, what is in blue are the variables to be filled in by the data set's corresponding column data. Basically I'm not sure how to put the two together.

Thank you,

Kim

[binuacs]

@kas Are you expecting like below for each customer

[kas]

@binuacs - this looks super close and think I can work with this!

Can you please upload it as a workflow so I can check out the tools?

[kas]

@binuacs 

Actually from your example I figured it out and simplified using the table tool.

Your example gave me the 'Append fields' too that was my missing piece...thank you!

Adding in the solution and output for reference.