Hi,
I have large dataset(more then 15,00,000 rows)
In one column I have Amount stored as text eg: $15,000.00 $ 12,000.00 $ 17,520.00
Data is imported from various small files and is updated regularly.
Now I need to filter dataset based on this column criteria like > 15000, <= 5000
How can I configure query to filter data.For example data are:
Id Detail Value Part 25252 Some text here $17,294.00 1 14202 Some text here $18,684.00 2 12142 Some text here $9,214.00 1 35214 Some text here $1,214.00 2 78565 Some text here $17,714.00 1 95214 Some text here $13,274.00 6 96587 Some text here $19,684.00 4 78563 Some text here $8,374.00 3 85634 Some text here $10,714.00 1