If I just want to do a static lookup on one field how do I specify which field I want the static lookup to be done on? When I try putting things in, it creates a new element instead of updating the existing.
Hi @jackharris,
In a Transformation step there's a little dropdown on the top left which lets you select if you want to create a new object or modify the existing one:
If you set it to "Modify input record" you should be able to use a static lookup on a specific field and not modify the other fields. See below:
I'm dealing with a repeating nested element. What I usually get is just that one element added to the end.
You would have to mimic the structure in transformation. So you'd have the first mapping be to ST and it would be an [object], then under that you map to Hierarchical Level as [object] and then finally to Product/Service as a mapping with string type.
@jackharris
See if this helps (a visual example of what Tyler wrote...)
1 Like