I have 40-50 csv files for different cities. I would want to show the number of records across time filtered by city and hashtag.
- The 'S.No' got aggregated and is showing the sum of records (I don't understand why did it shows the sum, shouldn't it be individual record numbers when performing Union?) i.e. Even if individual files have S.No from 1-50, the final table should show S.No from 1-2500. but that is not the case here.
Below image shows the data in query editor.
This image shows the table with aggregated sums in 'Data table view'