I’m posting this here as a bug and feature-request.
I uploaded a csv file with “;” as a separator as a Dataset.
QuicckSight doesn’t detect it as a separator, but it’s ok, I just have to change the upload settings and it’s all fixed.
The problem comes when I try to update this file with another.
id;age;name 1;32;Jean 2;35;Marc
The new file still has “;” as a separator, so all the columns are not detected, thus I get the error :
Fields missing with age and name.
This is because the custom upload setting I set earlier wasn’t taken in account.
For now I can just edit my csv file manually so QuickSight understand the file structure, but it would be nice if I didn’t have to do this in the future.
I basically see 2 solutions:
If there is a cutom upload setting then QuickSight should use it instead of the default.
Ask for the upload setting when previewing the data instead of after importing it.
Maybe right here :
Let me know what you think
Have a good day everyone