regarding the column distinct feature

[#1]

Want to disaply the distinct  data like this

I have column like  country  is

IND

IND;#ENG;#PAK

ENG;#WES

AUS;#IND

IND;#BAN:AUS

i want to display

IND

ENG:#PAK(since IND already came)

WES(Since ENG alrraedy came)

Please suggest me the solution

[santiago_respane]

Hi Thiru,

Do you mean that you want the records to appear only if they where previously loaded?

please can you elaborate more?

Kind regards,

[Gysbert_Wassenaar]

Temp:

LOAD ID, Country Where Not Exists(Country);

LOAD SubField(Country,';#') as Country, RecNo() as ID INLINE [

Country

IND

IND;#ENG;#PAK

ENG;#WES

AUS;#IND

IND;#BAN;#AUS

];

Result:

LOAD Concat(Country, ';#') as Country Resident Temp Group By ID;

Drop Table Temp;

[#4]

Hi Santigo,

I have a field called country    so i crated a multi box as a filter,when i select more then any value from multi box

then i have  on more text box is there in dashboard

Country -----------------------

here it has to show

IND

ENG:#PAK(since IND already came)

WES(Since ENG already  came)

but actual is

IND

IND;#ENG;#PAK

ENG;#WES

AUS;#IND

IND;#BAN:AUS

so how to get that

Please do the needful