Forum Discussion
Quick question on querying a large file
I have a fairly large CSV file that contains a flag designating domestic business versus international business. The full file contains both. What would be the best way to consume the data? I can pull it twice giving each query a different name and filtering on the column that contains the flag. Or, is there a better way to do this?
Steve
you can connect to the file once, then reference that query in 2 separate new queries - filtering one for domestic, one for international
this way whenever you change the connect file both dependants will get the latest reference
2 Replies
- Stachu
Community Champion
you can connect to the file once, then reference that query in 2 separate new queries - filtering one for domestic, one for international
this way whenever you change the connect file both dependants will get the latest referenceThanks. That did work but I had to go look up how to add query2 and query3 based on query1.
