New lookup table defined with AppendOrUpdate behavior, but Import From File feature does not respect that setting
Posted: Mon May 07, 2018 8:45 am
Hi-
I’ve defined a new lookup table using the AppendOrUpdate behavior for new entries.
Then, when I use the “Import from File” feature to bulk import entries from my spreadsheet (which contains duplicates), it displays a success message which confirms that # of rows were imported from my spreadsheet (dupes included). And so, the Lookup Table editor now contains the dupes. ( I expected the aforementioned behavior to treat my dupes as updates to existing entries and NOT add another grid row for each of them.)
Thus, when I attempt to Save my edits, I get an error because duplicates exist in the grid.
Bug or user error ?
Thanks.
I’ve defined a new lookup table using the AppendOrUpdate behavior for new entries.
Then, when I use the “Import from File” feature to bulk import entries from my spreadsheet (which contains duplicates), it displays a success message which confirms that # of rows were imported from my spreadsheet (dupes included). And so, the Lookup Table editor now contains the dupes. ( I expected the aforementioned behavior to treat my dupes as updates to existing entries and NOT add another grid row for each of them.)
Thus, when I attempt to Save my edits, I get an error because duplicates exist in the grid.
Bug or user error ?
Thanks.