Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
im hoping the community can help me with something simple.
I am getting 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.
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 to ignore duplicate dates? thanks
HI
it seems your date field is actually a timestamp with date and hour
how do you know which record to load ,
the first one or the last one