Is there some way to have the destination remove Columns which contain no information?
So after the file processes if there is no information what so ever under the header then just remove the entire column.
Is there some way to have the destination remove Columns which contain no information?
So after the file processes if there is no information what so ever under the header then just remove the entire column.
As it stands, Centerprise cannot do this. In Centerprise the layout is always static and cannot be changed depending on the data.
You could create a custom program that would do this. You could then create a workflow task that would perform this "clean up" if necessary. You could either build a custom workflow task or just use the "Run Exe" task to point to this exe or batch file.
Note that this workflow task solution pertains to Enterprise edition only.