Hi everyone, I try to set an attribute to true for all elements having a certain ID, when 2 defined activities are available for that certain ID. In my optinion the corresponding SQL query would be:   Update t set isvalid = true where id in (select id from t group by id having activity = 'a' and activity = 'b')   A result might look like: id activitiy istrue 001 a true 001 b true 001 c true 002 a false 002 c false 002 d false 003 a true 003 b true   Is there an option to execute this in SPL?   Thanks, Lukas ... View more

Hi, I have a lot of event data, where every instance can be idendified by a unique ID. Every instance contains several activities. Some activities occur not only once. For some this is okay, but for others I would like to add e.g. a "_2" at the end of the activity name for the second occurence of this activity. As this should be performed only for the second activity within the instance and only for some activities within all, I was not sure if it is possible to transform the data with SPL in the way I need it to be.   Thanks for your support! ... View more