Hi, can anyone share with me how you can load data into qlikview and avoiding Qlikview's Distinct Load?

[#1]

I am a newbie to Qlikview; I want to load data into qlikviewapp but I don't want qlikview to do a distinct load what and how can I do this.  

loading data into qlikview and avoiding Qlikview's Distinct Load?

I appreciate any help.

thanks.

[jyothish8807 · Accepted solution]

Hi Murry,

Add a field rowno() in the script.

load

rowno() as Sino,

Direct_Hours,

Indirect_Hours

from <>

Regards

KC

[#3]

Thanks

[marcus_sommer]

Unless you used the DISTINCT key-word qlikview won't load any data distinct. But if showed data within the gui in a tablebox then only unique table-rows will be displayed. To use rowno() as record-identify like suggest from jyothish8807 will avoid it in a tablebox but you need such things only for checking data while the development - within a production-application are such ID's not helpful then they need only a lot of RAM without further use.

- Marcus