PDA

View Full Version : Transormation with variable excel header



shaphiro
02-15-2008, 09:20 AM
Hi all, I have to load an excel file into my postgresql database, but the excel file format is the following:

2007-01-01 2007-02-01 2007-03-01 ..... XXXX-XX-XX
Value1 Value2 Value3 Value N
.... .... ..... ....

The problem is that the number of columns is variable from one excel file to another one.
I'd like to use, for example, the row normaliser step but I have to specify exactly the field names ... and in this case are variable, so I can't do that.

Are there any transformation steps that can transform my data in this format:
2007-01-01 Value1
2007-02-01 Value2
...
...
XXXX-XX-XX ValueN

Thanks in advance.
Stefano