ETL Transformation / Dataset Edit Error /

Question & Answer
, , , , , , , , ,
1

Hi @Team, I have a dataset which contains Columns
A
B
C
D

Lets Suppose, the Column name “A” is changed to “AAA” then i am getting error in the datasets while refreshing. Is there any flexibility to change the Column in ETL layer of Quicksight like in Power BI.

If it possible to change like that, we directly modify Same field in Calculations / measures like in Power BI.

image
image1286×196 14.6 KB

For example: The Column “Value” is changed to “Actual Cost” at the data source level
in Power BI we can have the flexibility to change as well the calculations in which we used the Column “Value” directly without unnecessary risks or avoiding taking too much time to do all the changes.

is that feasibility or flexibility possible in Quicksight?

2

Hi @Venkat.Metadata,
You could try using customSQL, may look something along these lines:

SELECT
Value AS Actual Cost,
…
FROM your_table

Let me know if this is helps with what you’re trying to do or if you have any additional questions

3

Hi @Brett, Thanks for sharing the info.

I am using CSV files from S3.
Apart from Custom SQL, can we have the flexibility to change the Naming of a column in ETL layer of QuickSight?

4

Hi @Venkat.Metadata,
There’s an option to change the field name at the dataset layer as well:

image
image367×229 15.4 KB

5

Hi @Venkat.Metadata,
Following up here as it’s been awhile since we last heard from you; did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you

6

Hi @Venkat.Metadata,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you