How to get unique records from two different set of data? RRS feed

  • Question

  • I have an Orchestration which gets two different sets of data for same flat file schema. Lets call it Set A and Set B. I want to send out only those records from Set B which are not there in Set A. The size of each flat file can vary..average size is 600kb+. Can you suggest me a resource efficient way of doing this in Biztalk? Using any database for achieving this is last option.

    Thursday, February 21, 2019 1:41 PM

All replies

  • Hi,

    Would this be a possible solution:

    • Create schema for incoming Flat file format
    • Receive both Flat Files
    • Create a Transform/Mapping that uses XSLT to select only the records in Set B which are not in Set A
    • Send out resulting file



    Did my post help? Please use "Vote As Helpful", "Mark as answer" or "Propose as answer". Thank you!

    Thursday, February 21, 2019 2:20 PM
  • This definitely looks like a possible solution
    Thursday, February 21, 2019 2:47 PM