1 Reply Latest reply on Jul 14, 2021 11:47 PM by Rakshitha K. R.

    Query Options on XML Source in mapping task

    Matt Wilson New Member

      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.

       

      Example XML:

       

      <SourceProcess Name = "RNR.R.GRAD.SCHOOL.HIST">

         <StudentCourses>

            <Student>

               <USCID>xxxxxxxxxxxx</USCID>

               <Classes>

                  <Class>

                     <CID>20213:17808</CID>

                     <TermName>Fall 2021</TermName>

                     <Section>17808</Section>

                     <SessionCode>037</SessionCode>

                     <Course>CNTV-525</Course>

                     <CourseTitle>Entertainment Marketing in Today's Digital Environment</CourseTitle>

                     <Units></Units>

                     <Publish>Y</Publish>

                     <Distribution></Distribution>

                     <DistributionComment></DistributionComment>

                     <Instructors>

                     </Instructors>

                     <Overseers>xxxxxxxxxx</Overseers>

                     <Grade></Grade>

                     <Registered>1</Registered>

                     <AddDate>2021-04-05</AddDate>

                     <DropDate></DropDate>

                     <CancelDate></CancelDate>

                     <Operator>WEBR</Operator>

                  </Class>

               </Classes>

            </Student>

         </StudentCourses>

      </SourceProcess>

       

      Image of Query Options - Filter:

      Image of Query Options on Source