Recurring names

[Learnerr]

Good days,

I extract data from SQL.

In the Select section i have 2 fields called "Explanation" and "Group". 

In the LOAD part i would like to combine both fields as they have similar parts within them. I wrote LOAD part like this:

LOAD Distinct

Explanation& Group as Groups

When i run this code in the front i create a listbox with the Field of "Groups" but it brings me double things under it.

Such as : Explanation and Group contains a field called linkedin and it shows in the list box as LinkedinLinkedin.

What can i do to prevent that double thing?

Thanks in advance.

Kind Regards.

[anat]

Explanation& Group as Groups

means you will get below output

Explanation, Group,Explanation& Group

1,2,12

Linkedin,Linkedin,LinkedinLinkedin

A,B,AB

1,1,11

if you want distinct values in seperate field

load Explanation as Groups  from table

concatenate

load Group as Groups  from table

[Learnerr]

Dear anat;

I wrote my code like this but it doesnt work:

CONCATENATE

Table:
Load Distinct
MenuId,
Explanation as Groups,

Group as Groups


;
SELECT
MenuId,
Explanation,
Group

FROM XYZ

[anat]

Table:
Load Distinct
MenuId,
Explanation as Groups,

Group as Groups


;
SELECT 
MenuId,
Explanation,
Group

FROM XYZ

qlik will not accept same name twice in single load script.

[Learnerr]

Yes, but how can i combine both of them ?