Is there any function in Quick Sight that can create key column based on values from multiple columns. Like for example, in Qlikview we have autonumberhash128 which gives a hash key on the column values which were passed. This helps in creating a join key where there are multiple columns to be joined
Hi, have you try using the denserank function?
1 Like
I did not try that.
I created a key using md5 function in RDS sql and imported that key along as well along with rest of table in quicksight using custom SQL. It worked for me.