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
Solved! Go to Solution.
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?