Selecting relevant data from tables and matching records

[aclar286]

Hello! I was wondering if anyone could help me with this problem.

I have two tables in my workflow.  

The first has product information such as colour and size, and then shows how a percent for a  given product will change over months, for example:

				Month
Product ID	Colour	Size	1	2	3
XXWDH	Blue	S	0.02	0.3	0.56
DDLWP	Blue	M	0.01	0.05	0.1
DDLWP	Red	M	0.08	0.4	0.01

I then have a table with all the product records.  This has the same information as the first three columns, as well as identifying which month the product is in.  Example:

Product ID	Colour	Size	Month
XXWDH	Blue	S	3
DDLWP	Red	M	1
DDLWP	Red	M	2

What I would like to do is match the information from the 1 table with the relevant product, such as:

Product ID	Colour	Size	Month	Percent
XXWDH	Blue	S	3	0.56
DDLWP	Red	M	1	0.08
DDLWP	Red	M	2	0.4

So only calling up the relevant percent for that product and its features.

Any ideas?  Thanks for the help!

[JoshuaGostick · Accepted solution]

Hi @aclar286,

I've identically re-created your two sample data sets and built a workflow that produces your desired output. Let me know if this workflow solves your issue.

Thanks,

Josh

[aclar286]

Thank you, really simple solution that's worked perfectly!