Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Dynamic Header

prveenk86kumar
7 - Meteor

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 

 

prveenk86kumar_1-1654705750196.png

 

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

 

 

8 REPLIES 8
npariso
7 - Meteor

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
7 - Meteor

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

npariso_0-1654709507885.png

 

binuacs
17 - Castor

@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

 

binuacs_1-1654724874062.png

 

 

binuacs_0-1654724813192.png

 

prveenk86kumar
7 - Meteor

Please find my workflow 

 

prveenk86kumar_0-1654753224278.png

I have stated that my data starts from Line 8

 

 

prveenk86kumar_1-1654753267311.png

 

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

 

binuacs
17 - Castor

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

ddiesel
13 - Pulsar

HI @prveenk86kumar!

 

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

prveenk86kumar
7 - Meteor

@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

 

prveenk86kumar_0-1655359779789.png

 

I am starting the first row from 8

 

prveenk86kumar_1-1655359903091.png

 

And i want my output in proper formatted excel file

 

 

binuacs
17 - Castor

@prveenk86kumar Please upload your input file as well

Labels