How a new Column in formula tool

Question

I want to create a new column record header

My current input file is -

Age2019-11-12115$289$

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

Age2019-11-122019-11-13115$*empty to add the input from another file289$*empty

How do i automate this column creation task?

Steve

rafalolbert · Accepted Answer

@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 Answer

Hi @henrygeorge how about this:

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