How can we help?

Search for answers or browse our knowledge base

< All Topics
Print

pivot import mechanism

Details of the pivot import mechanism

Pivot import removes existing records and replaces them with input records (from the form compartment).

The import pivot fields define the combinations of items that designate the data to be replaced in the host table. The records corresponding to the “pivot combinations” in the host table are deleted and the records from the compartment are inserted.

The logic of importing by pivot is that of updating by complete record sets.

Example (pivot axes: PivotAxis1)

Example with only new records added (pivot axes: PivotAxis1)

Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
5
How can we improve this article?
How Can We Improve This Article?
Table of Contents