Where statement in load

[cwitman1]

I wanted to add a where statement that loads data that have the timestamp within the last 60 days.

What would this look like?

[beck_bakytbek]

Hi Chris,

check this: everyday sum of past 5 days

i hope that helps

Beck

[passionate]

Hi Chris,

Do you mean you want to load last 60 Days Data.

In that case use

LET vPeriod=  Today()-60

Load .....

From Source

Where Timestampfield = $(vPeriod);

Make sure timestamp format of both is same.

Regards,

Pankaj