Copy only one of repeated rows to another column

[Alvaro_Souza]

Hi Gliders,

I’m trying to create a new column for a client that its going to be used as a cart, so every time they add a new row means its a new product in this cart. but what im intend to do is to only show the first row of this products.

Example Column A:

-ProductA
-ProductB
-ProductC
-ProductB
-ProductD
-ProductB

This means that we have 3 products B and only one of the others, and what i want for the other column to be is the following:

-ProductA
-ProductB
-ProductC
-{blank}
-ProductD
-{blank}

so i can then us this column as the items to show in the cart.

Anyone know how to do this? to only show the first row that repeat itself and let the next ones blank?

[Darren_Murphy]

• Add a RowID column to the table
• Create a multiple relation that matches the Product with itself
• Add a Single Value column that selects the first RowID from the relation
• Add an if-then-else column:
  – If RowID is Single Value RowID, then Product.

That’s it.