How to join 2 tables and show all the results from one.

[FelipeLima]

Hello Everyone. 

I'am trying to do something that is really simple with Excel but i can´t do with Alteryx (with my skills).

I have a table which tells me an emissor code and the products that he sold. For example:

CodCliente	CodProduto
65979000186	300018518
65979000186	300032023
65979000186	300032048
65979000186	300032052
65979000186	300032060
65979000186	300032074
65979000186	300032075
65979000186	300032082
65979000186	300032191

I also have another table with all the 10 products the he should've sold.

For example:

CODE         NAME 

300018518 XPTO
300032023 XPTO2
300032052 XPTO3
300032082 XPTO4
300032074 XPTO5
300032075 XPTO6
300032191 XPTO7
300032048 XPTO8
300032045 XPTO9
300032060 XPTO

The output, should be: 

The Client Code.. all the 10 producst and a flag which says if he sold the product or not.

For example:

CodCliente	Code	Sold?
65979000186	300018518	YES
65979000186	300032023	YES
65979000186	300032048	YES
65979000186	300032052	YES
65979000186	300032060	YES
65979000186	300032074	YES
65979000186	300032075	YES
65979000186	300032082	YES
65979000186	300032191	YES
65979000186	300032045	NO

so .. basically what i need is to show the 10 products and indicate which one he sold and which one he didn't. that´s pretty easy to do with excel but with alteryx i'm trying and trying.. so if someone can help me... i will be very grateful.

Thanks everyone.

Regards,

Felipe Leocadio

[MSalvage · Accepted solution]

@FelipeLima,

I have attached a sample solution. I had to tie the Client to the list of codes required to sell. Which caused it to be a little more complex, but hopefully this will get you where you need to be.

Best,

MSalvage

[FelipeLima]

it works really well when i work with one emissor code. 

CodCliente	CodProduto
65979000186	300018518
65979000186	300032023
65979000186	300032048
65979000186	300032052
65979000186	300032060
65979000186	300032074
65979000186	300032075
65979000186	300032082
65979000186	300032191

but if i increase the analysis to more then one.. then it doesn't work anymore..

for example:

CodCliente	CodProduto
65979000186	300018518
65979000186	300032023
65979000186	300032048
65979000186	300032052
65979000186	300032060
65979000186	300032074
65979000186	300032075
65979000186	300032082
65979000186	300032191
148007000155	300032045
148007000155	300032048
148007000155	300032052
148007000155	300032060
148007000155	300032074
148007000155	300032075
148007000155	300032082
148007000155	300032191

are there any way to do with more then one CodCliente?

Regards,

Felipe

[FelipeLima]

I Added the emissor code to the group by and now it´s working properly.

thanks for the help :)