Hard to tell. Could you post some sample data?
Are you maybe missing a space between the single quotes? Or do you want to concatenate in other order:
Vorname & ' ' & Nachname
Or does your 'name' field is maybe called 'Name' in fact (Qv is case sensitive)?
Or does 'name' field contain another character instead of a simple space as separator?
edit: In general, can't see anything wrong:
if(Nachname & ' ' & Vorname = name,1,0) as Flag;
LOAD * INLINE [
Nachname, Vorname, name
Hans, Fritz, Hans Fritz
Hi Hans, I think that you lost a space between the name and the first name.
So, try this:
if(Nachname & ' ' & Vorname = name,1,0)
I hope that it help you,
Hey swuehl, i forgot to say that the fields "vorname" and "nachname" come from another exel file than the field "name".
Is the Problem maybe that they don't see each other ?
I thought i can just compare them over these attributes(name=nachname&vorname), they aren't really linked to each other.
If i need to link them before i can compare them, how do i make that?
Without seeing your data, if you have "nachname" and "vorname" in one (first) table, and "name" in another (second), you could create a compound key in your first table, such as
Trim(nachname)&' '&Trim(vorname) As NameKey
and alias your name field in the second table e.g.
Name as NameKey,
Your tables would then be joined by NameKey.