Upsert Functionality and Scenario Integration in the Inline Action Form and Table Widget Using CSV/Excel Upload

Ask the Community
1

Background

I would like to upload CSV or Excel files using the “inline Action Form and Table” widget to set values for simulations.
At the same time, I want to utilize the scenario feature to manage simulation-specific values.
When uploading a CSV file, I want rows with an existing primary key to be updated, and rows without a matching primary key to be inserted (i.e., an upsert operation).
However, currently, even if the primary key already exists, a new row is added instead of being updated.

Questions

  1. Is it possible to perform an upsert operation (update + insert) via CSV or Excel upload using the inline Action Form and Table widget?

  2. In addition, is it possible to enable the scenario feature while performing the above operation?