Hi everyone,
I just started using FME and am already getting stuck.
In my workspace, I import an excel sheet that contains a list of column names in one of it's cells. The list is in the following format: [“Column1”,“Column2,”Column3”].
I also import a larger dataframe from a .csv file that contains a lot of columns, more than there are in the list of column names.
Now I’d like to have a transformer completely remove all the columns in the larger dataframe that aren’t also in the list of names. I’ve already worked with AttributeKeepers and AttributeMappers, yet these can’t seem to receive a dynamic input.
If anyone has an idea on how to solve this problem (Preferably using solely transformers and without PythonCallers) I'd love to know!
