Table Look Up with different criteria

[newbiealt]

Hi, I have a look up table where the criteria are not the same for entries. 

For example, for Type A data, it needs to look up by Type and Category; while for Type B to Type D data, it needs to look up by Type only, it doesn't matter what the Category is.

May I ask how to achieve this in Alteryx?  Thanks!

Lookup table example

Type	Category	Value
A	Shopping	1.5
A	Dining	2
B	*	3.5
C	*	1.5
D	*	3

Data example

ID	Type	Category	Expected Output Value
1	A	Shopping	1.5
2	A	Dining	2
3	B	Shopping	3.5
4	B	Dining	3.5
5	C	Entertainment	1.5
6	D	Education	3

[DataNath · Accepted solution]

Hey @newbiealt, how does this look? We first of all just do a join based on the 2 fields to find the most granular matches that we need. Any that fail to find a match i.e. only join on Type, we just use a Find Replace to lookup the Type and append the relevant value. After that we just Union the two sets of results to get the whole table back together: