To include all incoming fields from an upstream transformation except those with dates, what is the correct procedure?

The correct procedure for including all incoming fields from an upstream transformation while excluding date fields involves utilizing both the All Fields rule and a Fields by Datatype rule. This approach is effective because the All Fields rule allows you to automatically select all fields being passed through from the upstream transformation, ensuring no fields are missed. The subsequent application of the Fields by Datatype rule specifically targets and filters out fields classified as Date/Time, thereby meeting the requirement to exclude those fields without needing to manually identify and delete them.

By combining these two rules, the process becomes streamlined and more efficient, allowing for dynamic data handling. This method is particularly useful in scenarios where the data structure may change over time, as it automatically adapts to include all non-date fields from the source data, reducing the need for continuous manual oversight.