I’ve a set of transaction data. I need to replace all products with an ID, which I did with String manipulation node (Multi-column). Now I need to it to be in original data.
I followed the above logic. At the end of executing the above loop, I ended up getting a very big dataset. (copies of dataset)
String manipulation (outside loop) have only 2 columns ID associated with product.
I need to replace products with product IDs. I have a transaction dataset, which contains only product names. I have extracted unique products from all transactions and assigned product IDs to every product.
Now I need to replace product with product IDs in original dataset. Instead of product names I need IDs in dataset.