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:
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...)
