Dynamic Column name

You have  to amend the path to the file of get excel value tranformation function, (double click on on first transformation)

There is no need to type dates  manually .
you can just copy and paste them into pivot.

 

I'm running the package you sent with the files in the zip.  Path is correct, when I open the package I see the data, so I delete the data and run the transformation nothing gets stored in the column.  I run the transformation without making and changes and the data that was previously in the column disappear.  I will continue trying different things to get it to work - thank you 

Here are some screenshots you may find useful

            Hi Peter, 
I'm unable to reproduce what you did.  I'm using the zip file you attached - I un zip it and create a transformation based on Case234.ats - I create a new then open case234.ats.  I change the path of all files to the path showing the screen shots.  When I run it, nothing happens, the execution log sys 42 records written but nothing actually happens.  I checked the second transformation and no data seems to be produced, when It should be.  I used the output file you sent which has data in the 10/29/2023 column but once I run it , it disappear.  The execution log shows an error but I don't see where it is.    Any idea?

 

"The execution log shows an error but I don't see where it is.    Any idea?"

Double-click on the last transformation and click OK

I can connect remotely and assist you if you wish.

Yes, I wish, please. Let me know how and when you want to connect