Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jasmeenkr
Contributor
Contributor

Selecting distinct values of field load script

Hi All.

 

I am trying to load distinct values of field.

I am using distinct key word but it is still carrying duplicates 

 

What I am doing wrong

Labels (1)
3 Replies
Vegar
Partner
Partner

LOAD Distinct will only give you one row of each identical complete row of your table. The LOAD SCRIPT below will reduce the source by one row containing A, B, C. The final count of rows will be 3.

LOAD distinct * inline [
FieldA, FieldB, FieldC
A, B, C
AA, B, C
AA, BB, C
A, B, C
];

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
jasmeenkr
Contributor
Contributor
Author

Hi All,

Table:

Load 2,3, from qvd 1--count 21

load 4,5 from qvd2--count 313

load 6,7 from qvd 3--53K

 

Table1:

Load 2,3 ,if(4='True',5) as count

resident table;

 

The count gets multifold

Vegar
Partner
Partner

I'm sorry, but I dont really understand your description. Could you try do describe it using a coulpe of tables and explain your desired output?

Plees ekskuse my Swenglish and or Norweglish spelling misstakes