Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Conditional join in schemas

Avatar

Avatar
Level 1
rebeccat1844660
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
rebeccat1844660
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
rebeccat1844660
Level 1

19-04-2021

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!

conditional join conditional schema join join Schema schema join xml

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

961 likes

Total Posts

1,090 posts

Correct Reply

509 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

961 likes

Total Posts

1,090 posts

Correct Reply

509 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

19-04-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

Answers (0)