Import Excel into Data Structure SQL
Comments
-
I know this may sound bad, but I have been trying for days to figure out how to import data in an Excel file into a data structure (table) that is SQL data. I cannot find what I need. Can anyone point me to something?
-
Hi GernDog,
I know this question is quite old, but Ill reply in case someone else has the same question.
There is a step called CSV To Database mapping that does this exact thing.
First create your Database Structure by opening "Create Datatypes/Integration" and selecting "Database Structure".
Define the fields the database should contain:This is my example CSV (Works with Excel files as well):
Create a new flow and search for the step "CSV To Database Mapping"
Select the input file type and configure the delimiter or worksheet index.Finally click on the "Show Item Mapping Editor" link and map the values from the CSV to the Database structure:
[i]edited by Vigersand on 12/13/2022[/i]
[i]edited by Vigersand on 12/13/2022[/i]
Howdy, Stranger!
Categories
- 2.1K All Categories
- 18 General
- 155 Installation / Setup
- 991 Flows
- 86 Rules
- 203 Administration
- 204 Portal
- 433 General Q & A
- 600 Forms
- 282 Reports
- 3 Designer Extensions
- 38 Example Flows
- 32 CSS Examples
- 1 Diagram Tile
- 5 Javascript Controls
- 139 Pages
- 1 Process Mining
- New Features
- 150 Datastructures
- 50 Repository
- 169 Integrations
- 25 Multi-Tenant
- 21 SDK
- 40 Modules
- 38 Settings
- 20 Active Directory
- 12 Version 7
- 34 Version 8