2 of 2 people found this helpful
The easiest option is to add a Lookup Value to the derived entity manually. You can access this information in the View Lookup page of the derived entity and use it as lookup information in your additional ETL.
There may be other ways to help the lookup by using a macro in the DS_SYSNM column, but I think that the option above would be the cleanest one.
Thanks for the suggestion, I think that is probably the simplest option.
I am looking to update a lot of derived systems so was hoping to find a way to do it without updating all the lookups manually.