Hello I would like to random select customernumber for each supplier in my database. By example i would like to see five customernumber for each supplier, and the selection of those five customernumber has to be random. How can i do this in Enterprise Guide? Exmple dataset: supplier customernumber A           10002 A           10003 A           10004 A           10005 A           10006 A           10007 A           10008 A           10009 A           10010 A           10011 B           10012 B           10013 B           10014 B           10015 B           10016 B           10017 B           10018 B           10019 B           10020 B           10021 and more Example Result supplier customernumber A           10003 A           10005 A           10007 A           10008 A           10010 B           10012 B           10014 B           10015 B           10017 B           10021 ... View more

I joined a table on itself, and in the output each column name appears twice, one column is called (example; name) and the other one (example; name1, done automatic bij SAS Enterprise Guide). In the next step i split the table so i can  place the results below eachother with a append. Is there a way to rename all collumns that end with the "1" so i can append the two tables? ... View more

, I want to send a survey to our customers based on a random selection, but i'am stuck. The problem is that a customers can appear within multiple categories (like customerid 1 and 2 in the example below) what can lead to duplicates in the random selection What i need is a example how to realise a random selection which selects random three customers a category without duplicaties. I'm using Enterprise Guide 4.3 input example category 1 customerid 1 2 3 4 5 category 2 customerid 1 2 8 7 10 output example category 1 customerid 1 2 3 category 2 8 9 7 ... View more