Hi QS Team
I have a Quality.CSV file ( Only 42 rows ) in which a column ‘Value’ having Currency Data type.
I have created dataset using this file. Value column data type is String in QS.
- Currency Data type in CSV = String in Quick Sight?
When i am converting this to #Integer or #Decimal(Float, Fixed ). I am getting below error
- Value is Numerical column, right? even in CSV file. Why i am getting the above error after converting , i mean showing Zero rows like we deleted everything.
In Power BI, data will show even after doing data type conversion.
Any Workarounds?
Hi @Venkat.Metadata
I think in the import the currency symbol can not be interpreted during conversion as number. I guess this will be a generic issue; not specific to QuickSight.
Your PowerBI example does not look like a one-to-one match with your currency example.
You could probably bring in your original value as String and in the dataset create a calculated field to replace the currency symbol(s) and then convert the string to decimal using the parseDecimal function.
Regards,
Giri
1 Like
@Giridhar.Prabhu ,
I am replacing $, comma(,) symbols from the Value Column like below
$1,500.71 to 1,500.71 to 1500.71 to 1500.71(Decimal_Fixed)
-
Can we Replace all symbols in a single step like Remove characters from a column like below
Remove( Column, ‘$’, ‘1’, ‘@’, ‘2’, ‘#’, ‘3’)
-
In future, suppose, we don’t have/get any symbols in ‘Value’ Column. Will these calculated fields work in the visual because i am using the final column 'ParseDecimal in the visual
Hi @Venkat.Metadata
You can nest the replace statements like this so you don’t need multiple calculated fields
In future if you don’t get the symbols the calculated field will still work as it replaces the value only if that value is found.
Regards,
Giri
1 Like
