Alteryx designer Discussions

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

How a new Column in formula tool

Highlighted
Asteroid

I want to create a new column record header 

My current input file is - 

Age2019-11-12
115$
289$

 

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

Age2019-11-122019-11-13
115$*empty to add the input from another file
289$*empty

 

How do i automate this column creation task?

 

Steve

Bolide
Bolide

 @stevegeorge,

 

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

 

image1.JPG

 

Thanks,

Rafal

 

#Excuse me, do you speak Alteryx?

Highlighted
Alteryx Partner

Hi @stevegeorge how about this:

OllieClarke_0-1573745723700.png

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

Labels