Join three tables with two join tools in the same workflow

davechndr

Hello everyone!

Attached, is a workflow I created for the purpose of outputting a table with the following columns - whether in Alteryx itself, or as a ".csv" file: When connecting an Output Data tool and the Browse tool at the end of the workflow, the output is blank. (I did this for a Produce store/market.)

Customer Last Name	Customer First Name	Product	Quantity*	Category	$Cost of Product to Store	$Total Amount Spent For Item	$Selling Price	$Total Amount in Sales

*Here, the assumption is that the quantity of any item that the store buys is the same as the store sells, so the beginning inventory at the beginning of June is the same as the ending inventory at the end of June, for each product.

In other words, the workflow runs fine but nothing gets output. I cannot figure out why.

Any help on this issue of an empty output file would be highly appreciated.

Thank you very much and Happy Fourth of July, in advance!

Best,

@davechndr

Produce_Store_Report.yxmd

danrh

The Select tools weren't the issue --- I removed them just to simplify things for my own sake, you can add them back if needed (as a side note, you can also use the Join tools themselves to select/de-select fields).  I got the workflow working by changing what fields were being joined in the Join tools.  For instance, in the first Join tool the configuration was:

And I changed it to:

"Customer" is the field that exists in both of the datasets and the thing that ties them together. 

I did similarly for the second Join, changing "Item Name = Item Name" to "Item Name = Item No." --- when I looked at the data, while Item Name existed in both datasets, the data itself showed that the same data was in Item Name in the first dataset and Item No. in the second.

Does that make sense?