Desktop productivity for business analysts and programmers

Query Builder - Display Distinct Rows Based On ID

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 13
Accepted Solution

Query Builder - Display Distinct Rows Based On ID

How do I display only distinct accounts/IDs?  Right now the output pops out dozens of the same exact row, except certain columns have different dates.


query_builder.png


Accepted Solutions
Solution
‎09-27-2017 11:31 AM
Super Contributor
Posts: 341

Re: Query Builder - Display Distinct Rows Based On ID

Posted in reply to Fistful_Dollars

Just keep the ID column Smiley Happy

 

Then use the resulting table to join with other data you need.

 

//Fredrik

View solution in original post


All Replies
Solution
‎09-27-2017 11:31 AM
Super Contributor
Posts: 341

Re: Query Builder - Display Distinct Rows Based On ID

Posted in reply to Fistful_Dollars

Just keep the ID column Smiley Happy

 

Then use the resulting table to join with other data you need.

 

//Fredrik

Occasional Contributor
Posts: 13

Re: Query Builder - Display Distinct Rows Based On ID

[ Edited ]

Great, thank you FredrikE.  Worked very well.  I created another query(see below) to use only for joining.  There was another column ID I needed.  I used the MAX function for that column so there would be no repeat IDs from the first column, and because I only need the highest number for that variable.

 

SAS_Query.png

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 341 views
  • 2 likes
  • 2 in conversation