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

[marcus_sommer · Accepted solution]

Yes it should work with:

set vTestVariable= where Match(Kostenstelle,107,105);

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);

- Marcus

[Anil_Babu_Samineni]

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

Marcus solution should work, Don't worry about error in script. It won't effect your reload.

[beck_bakytbek]

Thanks a lot Marcus for your help and advice

Beck

[beck_bakytbek]

Anil Babu thanks a lot for your help

Beck