Star is Question

[#1]

Hi,

I'd like to link two tables and I have to use Star is:

Star is %;

Group:
LOAD * INLINE [
%_Key, Group, City
X1%, Group_1, Berlin
X2%, Group_2, Moscow
X3%, Group_3, Milan
X44%, Group_43, London
];


Contacts:
LOAD * INLINE [
%_Key, Name
X1223, Client_1
X2231, Client_2
X1211, Client_3
X3315, Client_4
X2134, Client_5
X4422, Client_6
];

Unfortunately this isn't working!

Is it possible to set a range, e.g. X21% to X31% = Boston?

Anyone an idea? Thanks in advance.

[#2]

Hi Elzo,

See attached and comments in the script.

Regards,

Gordon

[#3]

so there's no way to get it working with star is * ?

My source is an excel file. Would i be possible to fill up the missing values as an alternative way?

[#4]

Is it possible to left join with a key-field that contains *?