Advanced-etl-processor
Loading data from the Cross/Pivot table
Let us say we have table like the following in the database:
| No | Field | Data Type |
|---|---|---|
| 1 | CUSTOMERID | CHAR |
| 2 | YEAR | DECIMAL |
| 3 | MONTH | DECIMAL |
| 4 | PRODUCTID | DECIMAL |
| 5 | AMOUNT | DECIMAL |
And a text files like the one below:
Year
CustomerID
ProductID
Month_1
Qty_1
…
Month_12
Qty_12Pivot starts from column 4, it has 6 blocks and block size is 3
Click Data Source Button and check ‘Source file is a Pivot table’ check box and set First Field to 4, Blocks to 12 and Block length to 2
Map the data
Finally we are ready to import data
Click to load data into the database
Video Tutorial
We have more videos on ETL-Tools.com YouTube Channel,
Please take a look and subscribe to stay updated with the latest content.
For more technologies supported by our ETL Software see Advanced ETL Processor Versions
Confused? Ask question on our ETL Forum