Using a loaded field in a other load statement

[FrankGrimm]

Hello together,

i load a table

TOFIND:

load * inline [

TO_FIND

FRANK

];

Then i want to load an other table, but only where name is "FRANK". This is the content of the field TO_FIND which was filled with the first load statement.

NAMETABLE:

load * inline [

NAME

PETE

SOFIE

FRANK

JOHN

] where '$(TO_FIND)' = NAME;

It dosen´t work,

Whats my error?

Thanks to all!

Frank

[FrankGrimm · Accepted solution]

..sorry for my post.

I solved it:

TOFIND:
load * inline [

TO_FIND

FRANK
];

NAMETABLE:
load * inline [

NAME

PETE

SOFIE

FRANK

JOHN

] where exists(TO_FIND,NAME);