i have a common usecase: really common. I have a table from csv: Date, Customer, ItemId, qty_sold, qty_returned
what is the kmath recipe to pivot distinct ItemId to new columns Date, Customer, qty_sold_ItemId1 ,qty_returned_ItemId1, qty_sold_ItemIdN, qty_returned_ItemIdN,...