Can you try with a concatenated Key?
if(isnull(END_DATE) or trim(END_DATE) = '', date(today(), 'MM/DD/YYYY'), END_DATE) as END_DATE,
AutoNumber(PART&CUSTOMER) as Key
I will attempt to ask the question again.
The way I read the help text it says you can have more than one key field when using the interval match prefix.
IntervalMatch (matchfield,keyfield1 [ , keyfield2, ... keyfield5 ] ) (loadstatement | selectstatement )
"When the IntervalMatch prefix is extended with key fields, it is used to create a table matching discrete numeric values to one or more numeric intervals, while at the same time matching the values of one or several additional keys."
Has anyone got this to work?
I am not looking for a composite key, I already know how to do that.
The best way to check is to test it out. Here is a code which seems to be working for me
Date(If(IsNull(End) or Trim(End) = '', Today(), End)) as End
(ooxml, embedded labels, table is Sheet1);
(ooxml, embedded labels, table is Sheet2);
IntervalMatch(SHIP_DATE, Customer, Part)
Left Join (Table1)
DROP Table Table2;