Hi,
I've got a lookup with a number of records, and not all of them have all columns populated. Is there a way to append only those columns which are not empty?
Something similar to:
| lookup mylookup lookup_key OUTPUTNEW list of columns to append
| <some SPL here to hide columns which are empty>
I'd be grateful for any tips. I was experimenting with foreach but with no results.
Regards
