Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello together,
i load a tabel with only one value.
VALUE_FIELD:
load * inline [
TO_FIND
Frank
];
and i want to use this value to build an "WHERE" for an other load process.
NAMETABLE:
load * inline[
NAME, GIVENNAME
Frank, Smith
Eve, Brown,
Joe, Miller
] where ......the NAME is = Frank
I'm not able to use ...... where exists(NAME,TO_FIND)
So i want to tranport the value of TO_FIND (Frank) to a variable to use the following "Where" order
....where NAME="TO_FIND"
Thanks a lot
Hi @FrankGrimm
please try this -
Let vTemp= (Peek('TO_FIND',0,'VALUE_FIELD'));
and filter - where NAME= '$(vTemp)'
Hi @FrankGrimm
please try this -
Let vTemp= (Peek('TO_FIND',0,'VALUE_FIELD'));
and filter - where NAME= '$(vTemp)'
Hi MendyS,
perfect solution.
Thanks al lot!
Frank
Hi @FrankGrimm ,
you were close, but instead of
Where Exists(NAME,TO_FIND)
it should be
Where Exists(TO_FIND,NAME)