Multiple Criteria JOIN

[daniele_zatti]

Hi there,

I'm stuck in trying to connect two tables. The first one is a database looking like the following:

SKU	Category	Season	Color	Size
1	Shirts	Spring/summer	Red	M
2	Shirts	Fall/Winter	Blue	M
3	Jackets	Spring/Summer	Yellow	L

The second one contains information on campaigns that are run based on certain criterias applicable to some or all the above:

Campaign	Category	Season	Color	Size
-20% on Spring/Summer Shirts	Shirts	Spring/summer	*any*	*any*
-10% on Red Jackets	Jackets	*any*	Red	*any*

Consider we have 50+ Campaigns but each SKU should be on only one campaign at a time (has to be validated). How can associate the Campaign to each SKU in table 1?

Thanks,
Daniele

[Qiu · Accepted solution]

@daniele_zatti 
I hope you only wild card is the *any*.

There is a similar question below.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Join-with-wildcard-for-some-fi...

[daniele_zatti]

Thanks, Qiu, this is very close to what I'm looking for.

How can I now have an output table that has all infomration from tbale 1 and the campaign name (even if there is no campaign associated)?

Thanks,
Daniele

[Qiu]

@daniele_zatti 
Glad it helps.

Since we already know which SKU is having Campaign code, we can use a join then union with Left Anchor output like this