Inserting my date field to the top of the dataset

[wonka1234]

Hi,

How can I insert my date field to the top of the dataset.

I want my expected output to be like

2023-01-05
Header	Header2	Header3
data	data	data

I want to insert this (without date header) into my dataset.

[FinnCharlton]

Hello, I think my answer to your previous question will help you here. Your approach of using a Union tool to add the date, then the field names, then the data will work in this case. You can "skip field names" in the output tool to remove the Date header from the output. If this doesn't work, feel free to share a workflow and I can have a closer look.

[Felipe_Ribeir0]

Hi @wonka1234 

I dont know if your date column is a separated dataset, if it is, here is one way of doing this:

[wonka1234]

@Felipe_Ribeir0  anyway to not show the headers in this? I want to keep the headers in row 2 only.

[gautiergodard]

Hey @wonka1234 

You could try doing something like this and adapt it to your workflow?

[Felipe_Ribeir0 · Accepted solution]

Hi @wonka1234 

If you mean not showing the headers on the excel output, yes. If you look at the output file that my workflow generated, it will be like this (because of the option Skip Field Names inside of the output tool):

But if you mean not showing the headers inside of Alteryx, unfortunately i dont think that this is possible. Every Alteryx column must have a header there.

[HomesickSurfer]

Hi @wonka1234 

Make use of the Report Text tool, placing the date above the data table.