Hi everyone, currently i am running a store. all the transaction data in excel files. I have a list of products and another list of customers' numbers. So 1 list is like this: product A, product B, product C...; the other is like this: Customer1: product A, product C Customer2: product B, product K, product X Customer3: product F So I want to combine the 2 lists into a binominal matrix: Product A, Product B, Product C,.... C1: true, false, true,.... C2: false, true, false,.... .... Is there anyway to achieve this? I am using rapid miner too! Thanks a million!