Dynamic Header

[prveenk86kumar]

HI All, I have designed a workflow but i want below Header (only the date) which is my input file to appear in my final output 

As highlighted above Date format is Merger & Center, how do i solve this ? Any help would be appreciated.

[npariso]

Hi Prveen - Please show me the current process you have in Alteryx. The most important thing is how Alteryx is reading in this table from excel. If you could provide an example workflow or even a table with the output, we can figure this out!

Make sure you remove any confidential/identifying information.

[npariso]

Just going based off of your initial question, this workflow is dynamic and repeatable and allows you to get the output you want.

[binuacs]

@prveenk86kumar one way of dong this with the Preserver formatting option in the output tool. First you need to create a template with all the formatting then let the workflow to just write on the specific range with the data

[prveenk86kumar]

Please find my workflow 

I have stated that my data starts from Line 8

How do i design this more effectively, do you still need my workflow  

[binuacs]

@prveenk86kumar yes please upload your workflow with your input file and expected result

[ddiesel]

HI @prveenk86kumar!

Yes, I think we need some dummy data and an expected output. I'm sure we can help!

[prveenk86kumar]

@binuacs @ddiesel @npariso  I am unable to upload the original input file it as some critical data in it, but i have removed some refrence and taken a snapshot of the same below. And i have attached my workflow

I am starting the first row from 8

And i want my output in proper formatted excel file

[binuacs]

@prveenk86kumar Please upload your input file as well