Q:

How to collate multiple files in AWK? 

I am trying to collate a series of .csv log files that are named by date (e.g., 2019-02-24.csv).  There are a bunch of them, so I'm trying to script the process.  I've crafted an AWK script that combines individual files: 
awk ' FNR==1 { while (/"_time",PIN,FULLNAME,OFFICE,Acronym,Name/) getline; } 1 { print } ' 2019-01-01.csv >> usage_history.csv

But I am failing when I try to string the AWK commands together with a control loop in BASH:
for i in {01..28}; do echo "awk ' FNR==1 { while (/\"_time\",PIN,FULLNAME,OFFCODE,Acronym,Name/) getline; } 1 { print } ' 2019-01-$i.csv >> user_history.csv"; done

When I run this, it prints out the correct commands to the command line, but the awk scripts are not executed (they only get printed).  If I run it without echo, I get errors telling me that the file doesn't exist; though all files are present: 
bash: awk ' FNR==1 { while (/"_time",PIN,FULLNAME,OFFCODE,Acronym,Name/) getline; } 1 { print } ' 2019-01-01.csv >> user_history.csv: No such file or directory

What am I missing in my loop? 

Here is a condensed sample of the command and  the error messages:
$ for i in {01..02}; do "awk ' FNR==1 { while (/\"_time\",PIN,FULLNAME,OFFCODE,Acronym,Name/) getline; } 1 { print } ' 2019-01-$i.csv >> user_history.csv"; done
bash: awk ' FNR==1 { while (/"_time",PIN,FULLNAME,OFFCODE,Acronym,Name/) getline; } 1 { print } ' 2019-01-01.csv >> user_history.csv: No such file or directory
bash: awk ' FNR==1 { while (/"_time",PIN,FULLNAME,OFFCODE,Acronym,Name/) getline; } 1 { print } ' 2019-01-02.csv >> user_history.csv: No such file or directory

A:

Could you please try following. 
awk '! /"_time",PIN,FULLNAME,OFFCODE,Acronym,Name/' 2019-01-[0-9]*.csv >> user_history.csv

Here following are the points why one could use this approach:
1- Use of for loop and calling awk command in that each time will be a overkill.  We should use smart approach when awk could read multiple files then we should sue it. 
2- Now comes the getline part which you tried in your code, so if we want to negate any string then simply negate it by using ! /string_to_be_skipped/ so it will look for only those lines which are NOT having this string. 
3- While mentioning file(multiple files) to single awk command I used 2019-01-[0-9]*.csv why because since you have NOT told if files will be created daily basis or not so in case we give it a loop style and that specific file is NOT present then we will get an error.  For an example let's say I use following awk command where I intentionally removed file named(2019-01-02.csv). 
awk '........' 2019-01-{01..29}.csv
awk: cannot open 2019-01-02.csv (No such file or directory)

So to avoid these kind of situations I have used 2019-01-[0-9]*.csv where it will only look for files which have digits after 2019-01-0 and will loop NOT run in a loop and complaint us that some xyz etc file is  missing.