I have a table with a column request ID and two columns namely Error code 1 and Error code 2 . I want to display a table where I have the request ID and a column error that creates two rows for each request ID with value of Error Code 1 in row 1 and Error code 2 in row 2 . Is that possible in Quicksight. I cannot do it using SQL Unnest () function because my data is in excel format.
@Iti QS is not a data transformation tool. you have to do that somewhere else.
1 Like
Hi @Iti, It will be great if you can share a sample of how you would like to visualize your data. There are certain options in the pivot table view that can help. Based on my understanding of your use case, I create below sample data with few assumptions like data type of the columns.
This data when visualized as pivot table can be shown as separate rows for each Request Id as show below. Are you trying to achieve something similar to this?
If your use case is different then plz share sample visual and data to look into this further.
Regards,
Karthik
Hi @Iti, Did @Karthik_Tharmarajan response answer your question? If so, please help the community out by marking this answer as "Solution!
Hello @Iti, without using SQL to transform you 3 error code columns into a single column that contains multiple rows for each Request ID, the solution mentioned by Karthik is going to be the best alternative to achieve the display you are expecting.