Quick question on querying a large file

[slukas]

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

[Stachu · Accepted solution]

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

[slukas]

Thanks.  That did work but I had to go look up how to add query2 and query3 based on query1.