Adding a new column and combine data

[izabelatrojanowska]

Hi! Could you please help me how to add the new column marked in red in output file based on the file workflows?

[atcodedog05]

Hi @izabelatrojanowska 

Can you explain the logic on how you are try to combine and create this new column? It will be helpful for us to provide a clear solution.

[izabelatrojanowska]

marked in red - when there is VenueCPTYLEI I need to add in column VenueCptyLEIName the CE_Name based on LEI from the workflows file. In this case VenueCptyLEI and RefDataCptyLEI are the same numbers as LEI in the workflows. The same for RefDataCptyLEIName I need to add the CE_Name from workflows conneted to LEI (here also RefDataCptyLEI = LEI from workflows).

[atcodedog05 · Accepted solution]

Hi @izabelatrojanowska 

You can follow the below approach for your use case.

Hope this helps :)

Please acknowledge if it helps :)