Hoping you can help with the following.
Referring to the 3 data tables below - I need a way to do a dynamic join of data so that Input_Data table is left joined with LEI_Status table to return the status field. It should be joined 3 times, once for each field name in the FieldName table with the results CAT together (union). i.e. join Input_Data.Broker_LEI with LEI_Status.LEI then join of Input_Data.AgentLender_LEI with LEI_Status.LEI then join Input_Data.TriPartyAgentLEI with LEI_Status.LEI. And CAT all 3 together. The field names in the FieldName table contains the column names for the join. These are not known until being pulled in from a config file at run time, hence it can't be hard coded and must be done in a dymanic loop. So far, I was trying to use a join node in a do while loop but with no success.
TradeId, Broker_LEI, AgentLender_LEI,TriPartyAgentLEI
1, A, B, C
2, D, E, F
3, H, I , J
Please sign in to leave a comment.