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_12
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
Finally we are ready to import data
Click to load data into the database
For more technologies supported by our ETL Software see Advanced ETL Processor Versions
Confused? Ask question on our ETL Forum
Last updated: June 14, 2015