1 Reply Latest reply: May 28, 2013 9:19 AM by Gysbert Wassenaar RSS

    Loading multiple expressions whitin a Field

    Damian Spyra

      Hi there!


      i've a simple inline table in my load script:


      LOAD * INLINE [

      Id, Name, Expression,

          1, NAME 1, "Count({ $<MASTER_GERM_SHORT={'Klebsiella pneumoniae ( ESBL-Stamm )'}> } distinct ID)"

          2, NAME 2, "Count({ $<MASTER_GERM_SHORT={'Klebsiella pneumoniae'}> * <MASTER_ATB_NAME_RES={'Piperacillin-R'}> } distinct ID)"

          3, NAME 3, "Count({ $<MASTER_GERM_SHORT={'Klebsiella pneumoniae'}> * <MASTER_ATB_NAME_RES={'Piperacillin-S'}> } distinct ID)"

          4, NAME 4, "Count({ $<MASTER_GERM_SHORT={'Klebsiella pneumoniae'}> * <MASTER_ATB_NAME_RES={'Piperacillin-I'}> } distinct ID)"



      so, i'm loading a column, which contains different expressions. What i'm intend to do is to compute/include this expresions in a table, so that every single row is computes different expresson. So that's the goal. The current state look's like that:



      My problem is, how can i assign the expression like SET with a variable, so that i get a result from a expression and not expression itself.



      Thanks for Ideas!!!