https://community.qlik.com/t5/QlikView/Duplicate-Dates-reading-from-text-file/m-p/1698158#M725994 <P>HI&nbsp;</P><P>it seems your date field is actually a timestamp with date and hour&nbsp;</P><P>how do you know which record to load ,&nbsp;</P><P>the first one or the last one&nbsp;</P> Thu, 30 Apr 2020 16:02:50 GMT lironbaram 2020-04-30T16:02:50Z https://community.qlik.com/t5/QlikView/Duplicate-Dates-reading-from-text-file/m-p/1698121#M725993 <P>Hi,</P><P>im hoping the community can help me with something simple.</P><P>I am getting&nbsp;duplicate values within my Qlikview app when im reading in from a text file. is there a way to just show unique values depending on date and time? ive tried the floor and distinct function with no luck. my duplicates dates, reading in from a text file look like this: 04/23/2020 02:00:00 . they would then have a number dates/times repeating.</P><P>the duplicate values are within the text file i am reading from that have the column "Date" i am reading in. is there anyway to have an expression in within my straight table or in the load code&nbsp;to ignore duplicate dates? thanks</P> Sat, 16 Nov 2024 00:45:18 GMT https://community.qlik.com/t5/QlikView/Duplicate-Dates-reading-from-text-file/m-p/1698121#M725993 BSCIknowlec 2024-11-16T00:45:18Z https://community.qlik.com/t5/QlikView/Duplicate-Dates-reading-from-text-file/m-p/1698158#M725994 <P>HI&nbsp;</P><P>it seems your date field is actually a timestamp with date and hour&nbsp;</P><P>how do you know which record to load ,&nbsp;</P><P>the first one or the last one&nbsp;</P> Thu, 30 Apr 2020 16:02:50 GMT https://community.qlik.com/t5/QlikView/Duplicate-Dates-reading-from-text-file/m-p/1698158#M725994 lironbaram 2020-04-30T16:02:50Z