Nick Young
1 min readMay 19, 2021

--

This part of the process is just a simple way of looking at the value in the first column/row of your CSV and determining the type of CSV it is from that.

So, if the first value in your CSV in the first row was “My TImestamp” then you’d put that in the Config.gs file in the switch statement where it says “Case”. IE: case “My Timestamp”:

Then inside that block of the case/switch statement, you’ll reference the table function that defines the rest of that particular CSV/table type.

If you have 2 types CSVs that have the same value in the first row/column, and want to process them differently…you’d need to rewrite the “detect_csv_type” function so you can pass in multiple values. IE: pass in the first and second values, or as many as needed to determine how one type of CSV is different than another.

Does that help? If not, let me know — feel free to email me at usaussie@gmail.com and we canshare screenshots or other details that might help figure out your issue.

--

--

Nick Young
Nick Young

Written by Nick Young

Cloud stuff, data, analytics; Google, Internet2 Advisory Boards & working groups. Higher Ed IT since 2002. @techupover and @usaussie on twitter

No responses yet