StudioX how can I filter on duplicate values in Excel column and add together the text from each row for duplicates

Help StudioX
,
1

StudioX how can I filter on duplicate values in Excel column and add together the text from each row for duplicates.

In Excel sheet column Order has a list of numbers, some duplicate and some unique. Column Shipping has text that I want to paste into a text box in another application.

I want to add together the text for the duplicate numbers and paste all together into the text box, not go line by line.

|Order |Line|Shipping|
|8158966|100|ITEM 100 (QTY: 6) Proof of Delivery: // Carrier: // Tracking number: |
|8158966|200|ITEM 200 (QTY: 2) Proof of Delivery: // Carrier: // Tracking number: |
|8158966|300|ITEM 300 (QTY: 1) Proof of Delivery: // Carrier: // Tracking number: |
|8158966|400|ITEM 400 (QTY: 10) Proof of Delivery: // Carrier: // Tracking number: |
|8158966|410|ITEM 410 (QTY: 4) Proof of Delivery: // Carrier: // Tracking number: |
|8160871|100|ITEM 100 (QTY: 1) Proof of Delivery: // Carrier: 0 // Tracking number: |
|8160871|200|ITEM 200 (QTY: 1) Proof of Delivery: // Carrier: // Tracking number: |
|8163448|200|ITEM 200 (QTY: 4) Proof of Delivery: // Carrier: 0 // Tracking number: |
|8163747|100|ITEM 100 (QTY: 12) Proof of Delivery: // Carrier: // Tracking number: |
|8163747|200|ITEM 200 (QTY: 1) Proof of Delivery: // Carrier: // Tracking number: |
|8163747|300|ITEM 300 (QTY: 1) Proof of Delivery: // Carrier: // Tracking number: |
|8163747|400|ITEM 400 (QTY: 5) Proof of Delivery: // Carrier: // Tracking number: |
|8163747|500|ITEM 500 (QTY: 1) Proof of Delivery: // Carrier: // Tracking number: |
|8163747|700|ITEM 700 (QTY: 1) Proof of Delivery: // Carrier: // Tracking number: |
|8163747|800|ITEM 800 (QTY: 2) Proof of Delivery: // Carrier: // Tracking number: |
|8163747|900|ITEM 900 (QTY: 2) Proof of Delivery: // Carrier: // Tracking number: |
|8163747|1000|ITEM 1000 (QTY: 1) Proof of Delivery: // Carrier: // Tracking number: |
|8163747|1100|ITEM 1100 (QTY: 2) Proof of Delivery: // Carrier: 0 // Tracking number: |
|8163747|1200|ITEM 1200 (QTY: 1) Proof of Delivery: // Carrier: // Tracking number: |
|8163747|1300|ITEM 1300 (QTY: 1) Proof of Delivery: // Carrier: // Tracking number: |
|8163747|1300|ITEM 1300 (QTY: 1) Proof of Delivery: // Carrier: // Tracking number: |
|8163747|1400|ITEM 1400 (QTY: 1) Proof of Delivery: // Carrier: // Tracking number: |
|8163747|1500|ITEM 1500 (QTY: 1) Proof of Delivery: // Carrier: // Tracking number: |
|8163747|1600|ITEM 1600 (QTY: 1) Proof of Delivery: // Carrier: // Tracking number: |
|8163747|1610|ITEM 1610 (QTY: 1) Proof of Delivery: // Carrier: // Tracking number: |

I’m struggling to find anything similar on the forum. I’d prefer as simple as possible if possible!

Many thanks
Heidi

1 Like
2

Hello @heidi.burnett

  • Excel Read Range: Read data into a data table

  • For Each Row in Data Table:

    • If CurrentRow(“Order”) = CurrentOrderNumber:
      • Concatenate CurrentRow(“Shipping”) to ConcatenatedShippingText
    • Else:
      • Send ConcatenatedShippingText to the text box
      • Set ConcatenatedShippingText to CurrentRow(“Shipping”)
      • Set CurrentOrderNumber to CurrentRow(“Order”)

  • Send any remaining ConcatenatedShippingText (after the loop)

Thanks & Cheers!!!

3

Hi, many thanks for the reply. I’m sorry to take so long to get back to you. I have been trying various ways with the read range, data table and if but cannot seem to get it to work.

I may not have been clear in my statement. I don’t want to concatenate the lines, I’m looking to do the following:

For Order 8158966 I want to be able to paste the 5 Shipping lines together line by line as they are into another text box in another application, just as they are below:

ITEM 100 (QTY: 6) Proof of Delivery: // Carrier: // Tracking number
ITEM 200 (QTY: 2) Proof of Delivery: // Carrier: // Tracking number
ITEM 300 (QTY: 1) Proof of Delivery: // Carrier: // Tracking number
ITEM 400 (QTY: 10) Proof of Delivery: // Carrier: // Tracking number
ITEM 410 (QTY: 4) Proof of Delivery: // Carrier: // Tracking number

I can append the lines to a word doc but the statement "If CurrentRow(“Order”) = CurrentOrderNumber " goes through all the order lines not just the ones that have the same order number.

Is there any way to just action on the duplicates, not the whole list?

Many thanks!
Heidi