Data change type bar disabled while joining

Q&A
, , , ,
1

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 ?

datatype err
datatype err1399×514 107 KB

2

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:
example-qs

Let me know if this helps! Thanks

2 Likes
3

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

Preview1_joining
Preview1_joining1843×783 101 KB

Preview2_joining
Preview2_joining1876×630 126 KB

4

Sorry for the late response, I missed your reply.
I see what you’re saying, my suggestion is:

  1. Previously change the data type to match one another
  2. If you can’t change it, create a calculated field from the key you want to use with the same data type as the second dataset

To view the Import Summary, check if that’s what you’re looking for: Using SPICE data in an analysis - Amazon QuickSight

Thanks

5

Thank you, this works.