This content has been marked as final.
Show 4 replies
-
1. Re: Same UPC # and different name
Hari Ankem Jun 11, 2018 11:41 AM (in response to Martin Roitman)Create a calculated field to get a distinct name for the UPC as shown below.
{FIXED [UPC]:MAX([Name])}
You can then use this field and you should see only 1 value for the name. Now, whether you want to use MAX or MIN depends on your needs. If you have a date field, you can modify the calculation to get the latest name always.
-
2. Re: Same UPC # and different name
Deepak RaiJun 11, 2018 11:47 AM (in response to Martin Roitman)
Will This Work? Please See Screenshot and attached
Thanks
Deepak
If it Helps, Pl mark it Helpful and CORRECT to Close Thread
-
Totals Multiple names.twbx 22.3 KB
-
-
3. Re: Same UPC # and different name
Martin Roitman Jun 15, 2018 8:17 AM (in response to Martin Roitman)Thanks for the help!!
Hari's idea work best for what I was doing.
I will keep Deepaks on hand too!
Cheers,
Martin.
-
4. Re: Same UPC # and different name
Hari Ankem Jun 15, 2018 9:48 AM (in response to Martin Roitman)Great. Please close this thread now.