topic Re: How to load latest records based on TIME in QlikView

How to load latest records based on TIME

Sonalidas1 — Thu, 18 Nov 2021 10:22:45 GMT

Hi ,

I am facing challenges, where I need the latest record based on my date and time , date and time field I get from report number.

By using date(date#(replace(subfield(file, '_' -1),'-1',''),'DDMMYYYYhhmmss')'DD/MM/YYYY hh:mm') as Datetime,

When I used max date () I get error like Datetime field not found.

Can anyone one help me to get solution

Re: How to load latest records based on TIME

sergio0592 — Thu, 18 Nov 2021 10:53:42 GMT

Hi,

Not sure i understand perfectly what you're trying to achieve but for be sure that your new field Date Time is recognized as TimeStamp you can try :

Timestamp#(date_field&time_field,'Format')

Re: How to load latest records based on TIME

Sonalidas1 — Thu, 18 Nov 2021 11:10:19 GMT

Date and time in one field, how to do, can you plz text me.

Re: How to load latest records based on TIME

sergio0592 — Thu, 18 Nov 2021 12:15:13 GMT

Can you send a screenshot your DateTime field?

Re: How to load latest records based on TIME

Sonalidas1 — Thu, 18 Nov 2021 17:24:32 GMT

Hi @sergio0592

Get the solution but now I'm struggling with join the table with master table,

Mastertable:

IP,

Device,

Status

From xyz.xlsx;

Left join(Mastertable)

Data:

IP,

Date,

Complaint

From ABC.qvd;

Load

Date(Max(date)) as maxdate,

Resident mastertable

Group by IP;

Exit script;

Can you tell me,how I will join this

Re: How to load latest records based on TIME

MarcoWedel — Thu, 18 Nov 2021 20:38:08 GMT

Please post some sample data and your expected result regarding the Timestamp interpretation question.
Once solved, please close this thread by accepting a solution.
For independent questions please open another thread with appropriate title.
thanks
Marco