
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
where match
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
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks a lot Marcus for your help and advice
Beck

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Anil Babu thanks a lot for your help
Beck
