We have incoming data with 40 fields, we need to take the values of these 40 fields and create a comma delimited list which then must be inserted into a field in the destination database. Is there a quick and easy way to do this in CDI? Alternatively, is there a way to pass an array or list object from CDI to a custom plugin?
Thanks!
I see we missed this post. Are you still trying to figure this one out?
We're doing it by simply having a very large expression.
I can see the value of transformations that would pack and unpack array values like this.
To create the packed field (as specified by the author of this thread) there would need to be a way to concatenate X inputs with an optional pre and post string and a delimiter. For example the ability to create the following result: {value1,value2,value3,value4} where the { is the pre string, comma is the separator, and } is the post string.
Likewise, we would need the ability to unpack an input into X outputs where the string {value1,value2,value3,value4} would parse out as follows:
Field1 | Field2 | Field3 | Field4
Value1 | Value2 | Value3 | Value4