Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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.
Thanks a lot Marcus for your help and advice
Beck
Anil Babu thanks a lot for your help
Beck