field info tool and compare it to what you want...
I already have a predefined workflow which i am using for the same client again and again whenever the new data comes up i just need to trigger the workflow.
So just want to know is there any way to check that some new column has been comes up in the raw input data as compare to previous runs for that client
that is still the manual task any other way
Hi @atulggrwl2
This is great usecase and common practice followed by few where users wants to know any new columns have been added. Here is how you can do it.
Workflow:
1. You need to have a lookup table with predefined field names used.
2. Using field info get field names of current input file.
3. Using join tool we will look into the left unjoin i.e fieldnames in input file but not in field mapping.
4. Using a message if i have any new fields (i,e row number > 0) then it triggers an error message. If no new fields are added left unjoin will be 0 (i,e row number = 0) so no error message will be triggered.
Hope this helps 🙂
@atcodedog05
Good one.
Saved in my collection for future use.
Agree with @atcodedog05 - the best way to do this is to do a field-info on the inbound data stream; and then compare it to a static set of fields that you've recorded earlier and thrown an error (using the Test or Message tool) if there's a difference.