Hi All!
I read some other posts around this but they were very old so I’m wondering if there is a new way to handle this.
I have the following table:
| ID | Value | Column 3 | Column 4 |
|---|---|---|---|
| 1 | 50 | ||
| 1 | 50 | ||
| 2 | 75 | ||
| 3 | 10 | ||
| 3 | 10 | ||
| 3 | 10 | ||
I want to get the value for each ID. It can be duplicated 2, 3+ times. Currently I’ll get the sum of the values by ID, which is not what I want. I want the unique value. How can I get this?
Hi @Derek_Sanborn,
You need to use LAC-A functions to handle the duplicates. Take a look at use case #2 in this article.
Hi @Derek_Sanborn,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?
If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.
Thank you!
Hi @Derek_Sanborn,
Since we haven’t heard back, I’ll close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.
Thank you!