So how do I do select only values from col2 which has Abc in col1. There’s this huge data of around 20-25k rows.
I know I could do this easily with query like below:
SELECT col2 FROM tbl
WHERE col1 = Abc
But I need to know how to do it with dataset function.
Another thing I’d like to know is, is it possible to merge a rows here?
I’m using MSSQL for this but I am trying to make this all at view side rather than through query.
Yes i know about pyDataset one but looking for other approaches to do the same. PyDataset loop takes time to return the result, around 10-15 seconds for huge data and more
I am wondering why you don’t want to do this with a query. By not going the query route you are going to be processing your large amount of data twice which is going to take more time. Another possibility is to create a View in your database, but that pretty much doing the same thing as a query.
I’m avoiding to go with query because the dataset I’m returning is fetched from different sources using multiple cursor functions. That puts this combined value in temp table all together in the temporary table and returns it as my result dataset