Hi i have an inline data where i have duplicate data and i want to remove duplicate data in data model how should i do that

[Vijen_M]

Name, Sales
A, 1000
B, 2000
C, 3000
D, 4000
C, 3000
C, 3000
D, 4000    

but i want that in data model it should show only unique value 

Name   Sales

A,  1000

B,  2000

C,3000

D,4000

[SerhanKaraer]

Hello Vijen,

Distinct prefix does exactly what you want.

LOAD DISTINCT Name, Sales INLINE [
Name, Sales
A,1000
A,1000
B,2000
C,3000
D,4000
];

 I hope it solves your problem.

[Vijen_M]

@SerhanKaraer  thanks for that but is there another way of doing that ?

[SerhanKaraer]

Hi,

There are 2 other ways:

LOAD Name, Sales;
LOAD Name, Sales, Count(1) as DummyMeasure GROUP BY Name, Sales;
LOAD * INLINE [
Name, Sales
A,1000
A,1000
B,2000
C,3000
D,4000
];

LOAD Name, Sales WHERE Id = 1;
LOAD Name, Sales, AutoNumber(RecNo(), Name & '|' & Sales) as Id;
LOAD * INLINE [
Name, Sales
A,1000
A,1000
B,2000
C,3000
D,4000
];