Hi All,
I was hoping to get some with a problem that I'm trying to solve. I have a module with a line item that is list formatted. In this module, the 'applies to' is a list that has 7 values. The line item in the module has the following items shown for each of the 7 rows:
item 1: Product A
item 2: Product B
item 3: Product B
item 4: Product C
item 5: Product C
item 6: Product C
item 7: Product D
I'm trying to identify items that are shown more than once and create an additional snippet of text at the end to effectively make each item completely unique. The output I'd like to see is:
item 1: Product A_1
item 2: Product B_1
item 3: Product B_2
item 4: Product C_1
item 5: Product C_2
item 6: Product C_3
item 7: Product D_1
NOTE: I do not want to set this up with a series of isfirstoccurrence logic that would require for me to setup a bunch of line items to accommodate any number of duplicate results. This logic needs to work with any number of duplicate results.
Can anyone solve this for me?! Thank you!
