Hi
I have a table with 500 entries. I am loading the data to qliksense using HIVE database. I have used SQL query to run the output. I don't get any error, the load is completed and I can visualize my sheets.
But if I download the data in excel sheet from my sheets. I can see I have duplicates.
For example :
SNO EMPNAME EMPID LOCATION
1 JOHAN 1234 Asia
2 Johan 1234 Asia.
I have the EMPNAME entries twice (uppercase, lowecase). But in my original database I have only Uppercase. I ran the query in HIVE and checked it. There is some issue from the qliksite. Please help me to solve this.