Load data from the Cross/Pivot table

Let us say we have table like the following in the database:

And a text file like the one below:

Year
CustomerID
ProductID 
Month_1
Qty_1
…
Month_12
Qty_12

On the cross table page check ‘Source file is a Cross table’ check box and set First Field to 4, Blocks to 12 and Block length to 2

Finally we are ready to import data

Follow wizard steps to load data into the database

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL forum

  • dewizard/howto/pivot_tables.txt
  • Last modified: 17/09/2018 09:44
  • by admin