- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Recurring names
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes, but how can i combine both of them ?