Conditional join in schemas | Community
Skip to main content
rebeccat1844660
rebeccat1844660
New Participant
April 19, 2021
Solved

Conditional join in schemas

  • April 19, 2021
  • 1 reply
  • 1123 views

Hi - 

 

I am trying to add a conditional join into a schema, where IF a field in the new schema = X, THEN join to Y table, ELSE join to Z table.

 

Does anyone know if this is possible? If so, do you have an example of the XML code that would be needed?

 

Thanks!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jonathon_wodnicki

Hi,

 

It's not really possible to do in schema- however you can add both joins and dynamically select them at point of use, e.g. with js initialization of query activity.

I once worked on a project that had a table composed of hundreds of unlabeled cols that were ~grouped in sets, e.g. column1+column318+column319+column618 would be one of many sets defined in an Excel doc.

Made it sort of manageable by using js init to select which groups to query and their relationships to other tables.

 

Thanks,

-Jon

1 reply

Jonathon_wodnicki
Jonathon_wodnickiAccepted solution
New Participant
April 20, 2021

Hi,

 

It's not really possible to do in schema- however you can add both joins and dynamically select them at point of use, e.g. with js initialization of query activity.

I once worked on a project that had a table composed of hundreds of unlabeled cols that were ~grouped in sets, e.g. column1+column318+column319+column618 would be one of many sets defined in an Excel doc.

Made it sort of manageable by using js init to select which groups to query and their relationships to other tables.

 

Thanks,

-Jon

    Terms & ConditionsAccessibility statement

    Loading footer...