The following:
ArrayFilter Code,Newarray,¶,lookup(“Products”,“ProductCode”,import(),“Item”,"",0)
does not work in Panorama X, although this scenario works fine in Panorama 6. Code is a field in the current database which contains entries separated by a return (essentially a return delimited array). Newarray is the array I’m trying to build and the rest should be obvious. The field Code is text and the field Product Code is numeric. It seems that import() is not working it’s way through the first array. All I get is a blank NewArray. If I replace import() with val(Code), and use only one entry in the Code field, the “item” will be looked up.
Is this a bug?