How do I emulate this join I'm doing in Tableau within Alteryx?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello -
I have email data I've visualized in Tableau that I now need to advance a bit further with assistance from Alteryx. Essentially I have a primary table (Transactions (Emails)) where each row is an email exchanged between two people, the timestamp, the sender's ID, and the receiver's ID. The second table I have (People Metadata) provides me the dimensions that describe the person (person ID, locations, department, etc.). I join the metadata table to the transactions table twice because I need to show the flow of communication so one is joined on Sender ID = Person ID and the other on Receiver ID = Person ID
This model enables me to see quantitatively how much email is being exchanged from one department to other departments, for example. How would you recommend I recreate these results in Alteryx?
Solved! Go to Solution.
- Labels:
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I would use 2 join tools like this:
The first join operates on [From] = [email address] and the second join operates on [To] = [email address]. You could de-select the email address fields and rename departments either statically or dynamically. I think that this is what you are looking to accomplish.
Cheers,
Mark
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks, Mark! That did the trick nicely. :)
