Using an field-value as an variable

[FrankGrimm]

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

[MendyS · Accepted solution]

Hi @FrankGrimm 

please try this - 
Let vTemp= (Peek('TO_FIND',0,'VALUE_FIELD'));

and filter - where NAME= '$(vTemp)'

[FrankGrimm]

Hi MendyS,

perfect solution.

Thanks al lot!

Frank

[MarcoWedel]

Hi @FrankGrimm ,

you were close, but instead of 

Where Exists(NAME,TO_FIND)

it should be

Where Exists(TO_FIND,NAME)