0

Suggestion for a new object in Centerprise

Topher Birth

October 16, 2012 16:04

Completed

Follow

Hello all, it has been a while since I submitted a suggestion here.
Here goes.

It would make my life so much easier if there was an object which could accept multiple inputs for a single field and then choose the 1st one which is not null to actually populate the field with.

Right now we have a custom function which gives 10 inputs and 1 output. If there is a field which is coming in from multiple fields and we just want it to us the 1st one then we line them up 1 by 1 to the input. The output then just returns one value from which-ever was not null first.

We have quite a few of these in every dataflow and it would be so much easier if there was one object that handled it.

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Mike O'Quinn July 11, 2019 16:36 Official comment

  This is handled by the switch transformation now.

• 1
  
  Mike O'Quinn October 16, 2012 16:05

   

   I'll talk this over with the dev team and see what we can come up with. This is especially difficult based on the way we do mappings. The destination is tied to a single mapping and does not allow for multiple maps to a single destination field. In your case, you want the first. Someone else might want the last or some other logic to determine which one.

  If we created a generic object, it would look like the function you've already created.

  Again, we'll have to talk this over and see what we can come up with. I'm going to put this in the feature request list.