How a new Column in formula tool

[henrygeorge]

I want to create a new column record header 

My current input file is - 

Age	2019-11-12
1	15$
2	89$

I want my output file to have such headers where date is added my one- 

Age	2019-11-12	2019-11-13
1	15$	*empty to add the input from another file
2	89$	*empty

How do i automate this column creation task?

Steve

[rafalolbert · Accepted solution]

 @henrygeorge,

Here you go, method i used includes:

- generate individual dates from a range (start date & end date)

- cross tab using a dummy value and rename ('Cross Tab' forces underscores)

- append to the original dataset and allow all append

Thanks,

Rafal

#Excuse me, do you speak Alteryx?

[OllieClarke · Accepted solution]

Hi @henrygeorge how about this:

It will add a column 1 day after the max column date