https://community.qlik.com/t5/Data-Movement-Streaming/How-to-SELECT-distinct-values-from-odbc/m-p/2126985#M1484 <P>I would like to load values from my database (odbc) and select only first and last value per timestamp. Or at least values per distinct timestamps instead of loading the entire dataset which is very large.</P> <P>How to apply filter or how to add 'WHERE' statement?</P> <P>Thank you in advance!</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Screenshot Select_Data_ODBC.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/117963i1E9937CB241C1BB7/image-size/medium?v=v2&amp;px=400" role="button" title="Screenshot Select_Data_ODBC.png" alt="Screenshot Select_Data_ODBC.png" /></span></P> <P>&nbsp;</P> Wed, 19 Mar 2025 23:02:17 GMT SK_ 2025-03-19T23:02:17Z https://community.qlik.com/t5/Data-Movement-Streaming/How-to-SELECT-distinct-values-from-odbc/m-p/2126985#M1484 <P>I would like to load values from my database (odbc) and select only first and last value per timestamp. Or at least values per distinct timestamps instead of loading the entire dataset which is very large.</P> <P>How to apply filter or how to add 'WHERE' statement?</P> <P>Thank you in advance!</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Screenshot Select_Data_ODBC.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/117963i1E9937CB241C1BB7/image-size/medium?v=v2&amp;px=400" role="button" title="Screenshot Select_Data_ODBC.png" alt="Screenshot Select_Data_ODBC.png" /></span></P> <P>&nbsp;</P> Wed, 19 Mar 2025 23:02:17 GMT https://community.qlik.com/t5/Data-Movement-Streaming/How-to-SELECT-distinct-values-from-odbc/m-p/2126985#M1484 SK_ 2025-03-19T23:02:17Z