LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: PGeee

If I set a DB Store to write out LoadedData and ErroredData, it always writes LoadedData repeating the rows are in ErrroredData. I tested this by inserting the same rows twice with a unique key. Somewhat annoying as I would like to process further nodes depending on data loaded or errored

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rboccuzzi

The loaded data is actually just a mirror of what is "attempting" to be loaded. It is true, if you want to find out what ACTUALLY loaded, you will need to remove those records from the loaded output pin.

The ability to choose the path based on data characteristics can be done quite well using the Meta Check node, which can look at things like count of records, and trigger other nodes to process based on it's output pin or clock. You could use this to trigger a path of nodes to deal with error nodes and send email, etc., as appropriate.

Cheers
Rich