Toggle Navigation
Product
Clients
Contact
Partners
Documentation
Blog
Release Notes
Technical Specifications
Implementation Guide
Prerequisites
Simple Example
Working with the Addin
Basic Concepts
Exercises
Export
Database
Create Table
Update or Insert data
Replace table
Batch Replace
Insert All
Insert New
Update All
Update Existing
Predecessor
Column Addition
Import
Database
Data from Table with partitioning
Data from Table with filtering and sorting
Data using Manual query
Excel
Multiple Workbooks
Multiple WorkSheets
Multiple Worksheets & Workbooks
Sheet Number
Repeated Column Headers
Variable Data Positioning
Ignore Blank Rows
Extra Data Columns
Variable Column Headers
Convert Blanks
Missing Columns
Operations
Fill, Stack and Remove Duplicates
Filter
Basic Filter
Custom Column
Contains Substring
Distinct dates
Nesting
Replace
Text Matches Regex
Lookup
Add Column From Key Range
Aggregation
All data
If No Match
If No Match
Match Only Once
Unique Items
Functions
Case Generation
Data From Database
Data From PDF
Export To Database
Export To Text
Fill
Import From Text File
Lookup
Pivot Table
Remove Duplicates
Stack Rows
Documentation
Functions
Functions
Case Generation
Data From Database
Data From PDF
Export To Database
Export To Text
Fill
Import From Text File
Lookup
Pivot Table
Remove Duplicates
Stack Rows