Hi there I'm trying to populate multiple rows from an underlying table into a calculated item in SAS CI - Does anyone know if it's possible? Example: A have a customer A in the customer table with a 1:N relation til a order table. In the order table I have order B, C and D that I would like to collate in one string like this 'B, C, D'. I want to use the calculated item in export to email, where I can only export one row per customer. By using the calculated item, the export will contain customer id, customer email and the string 'B, C, D'. I can find the last order and the first - and I can count them - but I can't find a way to show the whole array. Any inputs will be appreciated 🙂 Regards/Rikke
... View more