Adding a new column and combine data
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
izabelatrojanowska
6 - Meteoroid
‎10-22-2024
03:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi! Could you please help me how to add the new column marked in red in output file based on the file workflows?
Labels:
- Labels:
- Transformation
3 REPLIES 3
22 - Nova
‎10-22-2024
03:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
‎10-22-2024
04:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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).
22 - Nova
‎10-22-2024
04:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can follow the below approach for your use case.
Hope this helps :)
Please acknowledge if it helps :)
