Database log
Posted: Wed May 25, 2022 8:46 pm
I have linked my database to switch and am able to pull data directly from our database into a log csv file.
I would like to be able to upload the log into google sheets for formula functionality.
If I upload my "log" as an excel file, I am able to retain all of my columns but without the necessary currency formatting. If I upload it as a csv, the 2 (log) rows are only 3 columns wide where my query is returning for example 6 columns of data so my data is cut off in column length but I am able to retain my currency formatting.
In the example below is there any way to turn off the 2 rows of actual switch log info so that I am just returning my own data or is there a better solution for this?
I would like to be able to upload the log into google sheets for formula functionality.
If I upload my "log" as an excel file, I am able to retain all of my columns but without the necessary currency formatting. If I upload it as a csv, the 2 (log) rows are only 3 columns wide where my query is returning for example 6 columns of data so my data is cut off in column length but I am able to retain my currency formatting.
In the example below is there any way to turn off the 2 rows of actual switch log info so that I am just returning my own data or is there a better solution for this?