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:

       

      LOAD

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

       

      FROM

      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.

       

      Greetings,

       

      Robert