Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Meerza
Contributor
Contributor

How to remove some duplicate info

Hello.

I'm New in QS. Currently I have sample table below:

Meerza_0-1698739095502.png

Due to cells A3,C3,A4 and C4 is repetitive, i would like to eliminate the data and still remain the name on column B

Labels (3)
1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You can retain just the first name for each Number/Acc combination with 

LOAD
  FirstValue(CustomerName_UMA3_Final),
  etc...
From ...
Group By Number_List_UMA3, Acc_No_UMA3_Final;

Or concatenate all three names together in a single row with:

LOAD
  Concat(CustomerName_UMA3_Final, ', '),
  etc...
From ...
Group By Number_List_UMA3, Acc_No_UMA3_Final;

-Rob

 

View solution in original post

4 Replies
Mark_Little
Luminary
Luminary

Can you expand?

Do you mean you what to remove the Data on load i.e. don't load row 3 or is this just a want to show the table different in a visual?

Meerza
Contributor
Contributor
Author

Actually, all three names belong to single account number. That's  why i want to remove the repetitive info but not the name.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You can retain just the first name for each Number/Acc combination with 

LOAD
  FirstValue(CustomerName_UMA3_Final),
  etc...
From ...
Group By Number_List_UMA3, Acc_No_UMA3_Final;

Or concatenate all three names together in a single row with:

LOAD
  Concat(CustomerName_UMA3_Final, ', '),
  etc...
From ...
Group By Number_List_UMA3, Acc_No_UMA3_Final;

-Rob

 

Meerza
Contributor
Contributor
Author

Thank you very much for the solution. 🙂