Unauthorized vendors

[KA]

I can not figure out how to find the unauthorized vendors. 

[ShankerV]

Hi @KA 

Please find the unauthorized vendors below.

Actually you have already done the maximum. Authorized vendors from Left Join.

Right join gives the list of total transactions. Those transactions might include Authorized and Unauthorized also.

Post joining,

Left node gives the Authorized vendors who does not have even I transaction.

Join node gives the Authorized vendors matched with transaction.

Right node gives the Transaction with Unauthorized vendors.

Hope this helps!!! Let me know if you have more questions!!!!

Many thanks

Shanker V

[Raj]

This way you can flag vendor type

Hope this helps..!