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