Header Value --> UnPivot

Hello all,

I am sure that you can help me.

In a file from the customer the month date is in the header.



To process it further I need to UnPivot it.
 

How can I write the content of the header in the line?

Thanks
Thomas
 

Please have a look t the following Wiki article

wiki.etl-tools.com/docs/advanced-etl-pro...orming-data/unpivot/

Hello Mike,

thanks for the quick reply.

I expressed myself in a funny way.

The UnPivot works fine.
But I am wondering how to get the alternating month headers in the row.
I then form a delivery date from this.

Greets
Thomas

I see what you mean now.

Multiple ways of doing it as usual.

Add another writer.
Make sure that it only reads the first line
Make sure that fields are called MONTH01..MONTH12.
Then add fields values transformation
wiki.etl-tools.com/docs/advanced-etl-pro...-data/fields-values/
It will convert your data to   
MONTH01,VALUE
...
MONTH12,VALUE

And the last step is to join the data on the month field using the joiner

Please keep us posted on your progress 

Hello Mike,

runs great thank you very much!

 


Now a question about the date.
The output string is "Sum of 2023-05".
With the "Right" Length 7 transformation I make "2023-05" out of it.

 

Now I should make a date out of it.
In this case it is always the 15th in each month "15.05.2023".

What is the best way to manipulate this?

Thx and Greetings
Thomas

Looks great, I am glad you are making good progress.
One suggestion though: always place the transformer before the writer 

Regarding your question, it would use ensure suffix transformation function with -15 as the value
wiki.etl-tools.com/docs/advanced-etl-pro...rings/ensure-suffix/
You may also use Reformat date to change the date format