Hi all,

Recently got at question about "how to collect all properties coming from a file and use these to filter subsequent files".

There is an simple solution using the contains function.

you need to declare on initial expression the array

resize(@properties,0);

and on the expression

for #i in 1 .. numproperties() loop
    if not contains(@properties,ithpropertyname(#i)) then
        append(@properties,ithpropertyname(#i));
    end if;
end loop;

This way if the property hasn't been seen it will be added to the array otherwise ignore.

After that you can use the array @property on a similar way for the other pipelines.

Here I enclose an example that shows how to use contains on this particular case.

Tip: run in Debug mode (shift + F5) to see which properties are kept and which rejected.

HTH

Pedro