Complete Newbie - What is in our Basket

[David_JonesPoundland]

Good Morning Community,

I'm hoping one of you can help. I'm completely new to Alteryx and awaiting training however i thought i'd try and work through what i thought would be a simple workflow.
I have input some transactional data. i have filtered by a number of products and then joined these filtered products by transaction number back to the original data feed.
What i'm trying to do is produce 3 sets of data which i can summarise.
The first data set im expecting would be any transactions that have never contained those filtered products (I'm assuming that would be my left join output)
The right data output would be blank as all transaction from the filtered products would be in the original data.
The join output would be any transactions that have contained these filtered products. Within in this output i would like the dataset split by those that contain ONLY any of the filtered product and second would be any transactions that contain both filtered and non filtered products.

Am i missing something or is it not as simple as i expected?

Any help or advice would be greatly appreciated.

[griffinwelsh · Accepted solution]

@David_JonesPoundland Your first three statements are correct. You can achieve the desired extra output by joining the J output anchor of your join tool with the L output anchor of the same tool on your transaction ID. The J output of this new join will have transactions that contain both filtered and unfiltered products. The R and L outputs will have transactions with all unfiltered products and all filtered products.