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: