TS Filler, how to initiate a start date, replace NULL with STRING in row-1

orking on cleansing time series data, i know TS Filler can fill the gap. But if there any way to generate a start date other than the given date in the dataset? For example TS should start on 2011-1-3, but the first date given is 2011-1-31, and TS filler fills missing date after 2011-1-31(interval="week"). Generate Row tool may help?

there are a column of char/string data, how can i fill the NULL with the same STRING from previuos row?

test data attached.

Thanks!

TS_Filler_test.csv

Date Time

Preparation

Accepted answers

Ying,

Sorry, i may be confused

See another one attached

1. Convert the Date field to date using datetimeparse tool

2. find the start date of given date from the file ---DateTimeTrim([DateTime_Out],'firstofmonth')

3. Use TS Filler tool

4. For the rows came as null use Multi Row Formula tool to fill with the previous row

hope i am in right direction

All comments

Ying,

I already responded here to get start date or end date etc. you can refer it how to use Generate Row tool

http://community.alteryx.com/t5/Data-Preparation-Blending/DateTimeDiff/m-p/3775#M585

Look at this one too

awf_DateDimension.yxzp

Ying,

Sorry, i may be confused

See another one attached

1. Convert the Date field to date using datetimeparse tool

2. find the start date of given date from the file ---DateTimeTrim([DateTime_Out],'firstofmonth')

3. Use TS Filler tool

4. For the rows came as null use Multi Row Formula tool to fill with the previous row

hope i am in right direction

Quick Links

Tags

Workflow
Output
Preparation
Datasets
Input
Developer
Help
Tips and Tricks
Common Use Cases
Server
Transformation
Developer Tools
Macros
Data Investigation
Best Practices

This months top contributors

atcodedog05 19598

Qiu 15879

MarqueeCrew 13708

apathetichell 13703