Concatenate Comma Separated List

Suppose you have a set of fields, sometimes they are blank and sometimes not, like this:


If you want to concatenate these fields into a single comma separated list, things can get tricky.

You need to check whether a field is blank or not and include it accordingly. You also need to work out whether a column has a value after it and insert a comma accordingly.

Fortunately, Loadit has a “Concatenate” function that saves you having to deal with these details.
It takes a variable number of input fields and a delimiter and does all the concatenation logic for you, e.g.

Concatenate(",", false, [Source.ColA],[Source.ColB],[Source.ColC])


Attached is a worked example as a downloadable .lip file: