Hello. Fairly new to FME, so might be a bit over my head.
I’m trying to create a validation workflow that compares 50+ files against 3 main ones. They all have the same structure, except the geography field name that is to be used for the comparison.
The 50+ files are all named with a similar structure > final_DOMAIN_GEOG_Distance or final_DOMAIN_GEOG_Driving. Pretty much the files are divided by domain and 3 geographies.
The 3 main files are a compilation of all domains and GEOG.
My thought process was to have 2 csv readers (1 for distance and 1 for driving) and a few parameters that would read the user choice for domain and geography and read the csv accordingly.
I have two issues:
- the parameters for file path seem to work but the csv schema remains the same (eg, it’s reading the original reader before adding the parameters), so it doesn’t update the field name with the geography, when it’s different form the original one
- is it possible to create parameters that can be used in the transformers, so it always reads the right geography field name?
Hope it makes sense!
Thanks!
Maria