Skip to main content
V
vmanojrc30
June 27, 2023
Solved

Workflow - Load Methods

  • June 27, 2023
  • 2 replies
  • 0 views

 I have a source file that will be updated/changed with the entities being loaded every time when it is loaded via a WF.In Order to preserve the balances of the Entities previously loaded I am thinking to have Source ID same as my Entity Name as I don't see any "Merge" Mode Load Option in WF. Is there any other way or better option to load files in Merge Mode.

    Best answer by EricOsmanski

    Splitting by Source ID would work, but there is also an Append load option


    EricOsmanski_0-1687915759764.png

     

    2 replies

    E
    EricOsmanskiAnswer
    June 28, 2023

    Splitting by Source ID would work, but there is also an Append load option


    EricOsmanski_0-1687915759764.png

     

    V
    vmanojrc30Author
    June 28, 2023

    Thanks Eric! I tried appending and it accumulates the balances if an entity was previously loaded, and a new balance was updated for the same entity. So, I think in order to Merge the data split by source ID is the option.

    V
    vmanojrc30Author
    July 4, 2023

    I tried with Entity as Source ID to enable Merge Mode load. However, there is a restriction on number. of Source IDs per Workflow (1000).

    Appreciate any other suggestions to load data in Merge Mode.

    K
    kmd
    November 21, 2023

    Wondering why there is no Merge option to begin with?  Perhaps this is something that needs to be promoted to ideastream or whatever it's called now

     

    Terms & ConditionsAccessibility statement