Inner Join Workflow

Juan_NFCU
Juan_NFCU
edited December 2023 in General

We use the inner join workflow to look at the matching unique ID between 2 sources. This is used for monthly reporting and validate what information changed on specific columns between the months.

Is there a way to add more than just 2 sources? The join function only allows 2 sources to do a left, right, and inner join type. Not sure if there is another workflow function that we should be using to achieve this.

Thank you!

Comments

  • Josh Boxer
    Josh Boxer Administrator

    Hi Juan

    You will be pleased to hear we are about to begin building a new 'Compare data' Workflow step that will highlight the information that has changed, should do exactly what you are asking for!

    Current plan is that it will only be for 2 data sources, so our UX team might reach out to share the proposed designs with you over the next few weeks to ensure it will meet your use case.

    I think you want to Union the previous months together then Join or Lookup against the latest month, but would need to understand more about what you are trying to achieve using multiple sources

  • Adrian Westlake
    Adrian Westlake Administrator

    @Juan_NFCU I've reached out directly to you on this

Categories