If column has a value present then convert it into an additional entry into a row

Question

I am working with insurance policies where we can have additional coverage premium represented by a variable (as shown in image below ending with PA). I want to represent the premium for PA as a separate row entry. The tricky part is I want the new entry to have all the same features (policy from date, policy to date, policy no, etc.) as the original row entry, just have the Gross Premium PA value as Gross Premium value. you can see below what I have and what I want.

Thanks in advance!

Paridhi_Agrawal · Answer

Hi,

See if this workflow helps. I just took selected columns.

Thx

HadiElmo_Workflow.yxmd

DanM · Answer

@HadiElmo

You can accomplish this by using two Select Tools with two data streams. in one stream Uncheck your PA fields and in the other uncheck your non PA fields. Update your Subclass name with a Formula tool in the data stream with your PA information and then use the Union tool to put that data back together. You can then sort the data by policy and sub class.