I have created a table in a BigQuery dataset and upload it from my files, however when checking the table I see a difference in values(see the images), in particular the following variables, TimeAct, TotalIntensity and AverageIntensity.
In the BigQuery table they have values 0 as oppose to the original dataset in Excel where their value is NOT 0.
Schema was auto-detected and I had 1 header row to skip. I made sure the columns are formated in the correct format. I tried different formats (left it as STRING)
Any ideas?
Thanks in advance.
I tried to reproduce this error by taking a screenshot and convert to CSV. Then I go to BigQuery and create a table from an uploaded CSV file with auto-detect schema. I think I got an expected result below.
Here are my suggestion: