Mapping task pulls from XML flat file, transforms, and maps to object in Salesforce.
I have added a filter on the query options under the Source in a task flow but the records are not being filtered from upsert into Salesforce.
I'm attempting to filter out records where the Units field is blank or null.
The filter is NOT ISNULL(Units) - see image below.
The following XML has a blank Units field so should be filtered out, but it is not working properly.
<SourceProcess Name = "RNR.R.GRAD.SCHOOL.HIST">
<CourseTitle>Entertainment Marketing in Today's Digital Environment</CourseTitle>
Image of Query Options - Filter:
What is the Type of connection used here? Is it flatfile?
Send me the screenshot of how Fields are seen here in the Source.
Could you please see if you can explore Hierarchy parser or Intelligent Structure discovery to parses the XML. :