9 Replies Latest reply: Sep 29, 2015 6:55 AM by Robert Fernan RSS

    Renamed field in key

      Hey guys,


      I'm trying to clean up my script and reduce the synthetic keys. I hope someone can help me.


      My question is: Can renamed field be used within a key? As in:



      datum & '|' & UPPER(klant) & '|' & module & '|' & profiel& '|' & Year(datum) & '|' & Month(datum) & '|' &  if(len(datum)>0, 'Q' & ceil(month(datum)/3)) As Quarter as key,



      How do you go by renaming a field and using it in within a key? Is it even possible? What are possible alternative sollutions?

      And ofcourse how does it, if it does work with if statements within keys?


      Thanks in advance.