topic Re: show only 3pm data in Connectivity & Data Prep

show only 3pm data

Anonymous — Fri, 02 Apr 2021 08:06:29 GMT

I have timestamp column and I want to pick only 3 pm data from rest of data

oknotsen — Thu, 16 Nov 2017 08:30:58 GMT

Define "3pm".

There are various ways of doing this, but it all depends on what you exactly have in mind.

Anonymous — Thu, 16 Nov 2017 08:34:04 GMT

I have to show in column only 3.45pm,3.50pm like that

sunny_talwar — Thu, 16 Nov 2017 13:05:43 GMT

Do you want to exclude the other times in the script? May be this

LOAD ....

FROM...

WHERE Hour(TimeStamp) = 15;

On the front end, you can try this

{<TimeStamp = {"=Hour(TimeStamp) = 15"}>}