Concat Address Line 2 without extra comma

Answered

I'm creating a variable called property_address that is concat of address_line_1, address_line_2, city, state, zip.

Sometimes address_line_2 is blank, and since I am using concat, there is an extra comma ',' in the property address.

Is there a way to use an if statement or some other function inside the filter to make it so that the concat only runs if address_line_2 is empty to make it so there is not an extra comma?



5 replies