Is this possible?

Hello All,

Happy Friday 🙂

I have a conundrum that I would like your help with and I am not sure if it is possible! I am using a join to link a central set of values so I can compare to Values from various countries.

The left join is my Global baseline, the right my market data. When I have an instance from the left that doesn't appear in the right, I would like to append it with the Market code so I can see which global entries aren't in use in the markets. Below is a mock up of what I would like it to do!

Example file.xlsx

Datasets

Output

Join

Database Connection

Accepted answers

LordNeilLord

Hey @Bigmonki

Its always possible

You need to first create every possibility of Link & Market, I took a group of each market from the right and appended it to the left before my join.

Then when I do the join on link, value and market the L output gives the combinations that are missing

New Workflow7.yxmd

All comments

wwatson

can you post a snip of the join with it's inputs and outputs? Do you have a union after the join to pull the L and J outputs together?

LordNeilLord

Hey @Bigmonki

Its always possible

You need to first create every possibility of Link & Market, I took a group of each market from the right and appended it to the left before my join.

Then when I do the join on link, value and market the L output gives the combinations that are missing

New Workflow7.yxmd

Bigmonki

@LordNeilLord Genius! Everyday is a school day. It's always the simplest solution that should be the obvious, I must stop over thinking things.

Appreciate the quick response, this was a perfect solution. Have a great weekend.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703