4 Replies Latest reply: May 4, 2017 7:03 AM by beck bakytbek RSS

    where match

    beck bakytbek

      Hi Folks,

       

      i have a question:  my situation does look like: i have a example - table (see below)

       

      main:

      Load * Inline [

      Kostenstelle, Mitarbeiter, Umsatz

      102, James, 50

      103, Yoko, 75

      104, Hugo, 100

      105, John, 56

      106, Niko, 45

      107, Janina, 66

      ]

      where Match(Kostenstelle,107,105);

       

      and i use this. where Match(Kostenstelle,107,105);

       

      I want to ask, can i save this part of my expression in script  as variable? like:


      vTestVariable= where Match(Kostenstelle,107,105) ?

       

      expected output:

       

      main:

      Load * Inline [

      Kostenstelle, Mitarbeiter, Umsatz

      102, James, 50

      103, Yoko, 75

      104, Hugo, 100

      105, John, 56

      106, Niko, 45

      107, Janina, 66

      ]

      vTestVariable;

       

       

      my purpose is, i want use my varible at the beginning of script like a filter.

       

      Does have anybody any ideas?

       

      Thanks a lot for any help

       

      Beck