Join in Domo
Hi everyone! I am looking to get the below outputs for the for the following columns in Domo:
Distinguished Name Column: CN=Janet Jackson,OU=Users,OU=Technology,OU=TheArtFactory,DC=artfactory,DC=priv
Output needed: Janet Jackson
Manager Column: CN=Joe Jackson,OU=Users,OU=Information Technology,OU=TheArtFactory,DC=artfactory,DC=priv
Needed output: Joe Jackson
Thank you!!
Best Answers
-
Hi @Fadem
You can do this in a magic etl dataflow with a regular expression and a replace text tile.
Regular Expression:
^CN=([^,]*).*$
You can also just copy and paste the following JSON code into your MagicETL dataflow which should handle things for you:
{"contentType":"domo/dataflow-actions","data":[{"name":"Replace Text","id":"a028495a-46f9-4503-8e12-a43cfe640999","type":"ReplaceString","gui":{"x":276,"y":180},"dependsOn":["c9d8eab3-4065-417a-8bb7-d8be5e58edb6"],"removeByDefault":false,"notes":[],"fields":[{"inStreamName":"Column","useRegex":true,"replaceString":"^CN=([^,]*).*$","replaceByString":"$1","wholeWord":false,"caseSensitive":false}]}]}
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
No it should work in ETL1 or 2 using the Replace Text tile. You just need to make sure to put the regex in the search and $1 in the replace and make sure you click the gear in the search field and select Use RegEx
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Answers
-
Hi @Fadem
You can do this in a magic etl dataflow with a regular expression and a replace text tile.
Regular Expression:
^CN=([^,]*).*$
You can also just copy and paste the following JSON code into your MagicETL dataflow which should handle things for you:
{"contentType":"domo/dataflow-actions","data":[{"name":"Replace Text","id":"a028495a-46f9-4503-8e12-a43cfe640999","type":"ReplaceString","gui":{"x":276,"y":180},"dependsOn":["c9d8eab3-4065-417a-8bb7-d8be5e58edb6"],"removeByDefault":false,"notes":[],"fields":[{"inStreamName":"Column","useRegex":true,"replaceString":"^CN=([^,]*).*$","replaceByString":"$1","wholeWord":false,"caseSensitive":false}]}]}
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
@GrantSmith Thank you so much!!! I am assuming you have magic ETL 2 because I don't see any tile that would let me use the following expression.
0 -
No it should work in ETL1 or 2 using the Replace Text tile. You just need to make sure to put the regex in the search and $1 in the replace and make sure you click the gear in the search field and select Use RegEx
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
@GrantSmith You're Awesome! Thank you.
0 -
Glad I could help! If you could make sure to mark it as an accepted answer so others can easily find this I'd appreciate it!
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive