cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic data join

Hi,

 

I want to pull data from another data source using certain fields in my existing data set and where the match does not exist I'm fine with getting NULL value. Something like GETPIVOTDATA in the excel which we use to pull data for matching fields.

 

Thanks

  • Join
Garrett
Alteryx Certified Partner

Sounds like you need the Dynamic Replace tool.  Even older post but definitely informative: Dynamic Replace tool.

I'm not sure if this is what you were trying to achieve, but I have a sample workflow attached.

 

First text input has some field names... second input is your "other data source" that shares some of the same field names. Basically you bring in the whole data source and then through a series of tools (Union, Transpose, Filter & Cross-tab), you're able to filter the second data source to only the specified columns. It doesn't feel very efficient (would love to see if someone else has a cleaner solution)... but it should work for any number of chosen fields.

 

(Might be "cleaner" looking if this does work to turn it into a macro, so that your actual workflow shows just the one "tool" instead of the whole workflow.)

 

If that's not quite what you were looking for, could you perhaps attach sample data showing what you start with and what your expected outcome would be? Thanks!

 

NJDynamicDataJoin.JPG

Magnetar

Hey @pmittal_25

 

Welcome to the community, and congratulations on your first post!

 

Are you able to provide an example for us to work with you.   A great way to do this is:

- An example of your input data 

- a note about what you're trying to transform

- And an exmple of the output that would result from doing this to your input data?

 

You can mock this up in Excel if you need, and pop it into a quick alteryx flow - that should make it really easy and quick to get you to a solution.

Have a look at the weekly challenges for an example / template that you can use (here: https://community.alteryx.com/t5/Weekly-Challenge/bd-p/weeklychallenge)

 

Looking forward to seeing more on this one - have good week @pmittal_25

Sean