Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How a new Column in formula tool

henrygeorge
8 - 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

2 REPLIES 2
rafalolbert
ACE Emeritus
ACE Emeritus

 @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

 

image1.JPG

 

Thanks,

Rafal

 

#Excuse me, do you speak Alteryx?

OllieClarke
15 - Aurora
15 - Aurora

Hi @henrygeorge how about this:

OllieClarke_0-1573745723700.png

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

Labels