Hi,
When I am trying to join 2 .csv files in quicksight, while for the first dataset, I am able to make changes to data types but soon as I am adding the second data set file, the data type menu bar gets disabled. Due to this I am not able to modify few fields’ data types. How to resolve this issue ?
Hey @uprt12 !
You can close the PA_UFSCA_WHOLE_Population[…].csv window there, and you’ll be able to modify the field types.
I’m including a small demo here:
Let me know if this helps! Thanks
2 Likes
Hi @afalcao,
This largely resolves the issue, thank you. I tried this, but this worked only after I created the join. Before joining, the fields list is not visible. This leads to potential joining of 2 similar fields but with different data type- one is ‘string’ while the other is ‘date’ (here similar means, both the common columns hold similar data in nature). Is there any way to address this challenge ? Attached 2 images for comparison.
Also, Is there any tab or panel to view import summary, as in how many rows imported, truncated ? The message pops up but fades away.
Thank you
