Loop and Collections

Hello,
I have the following data:

Eng# —Agreement
111 ------LA1234
111 ------SC4567
333------ LA9877

I need to establish that for each Eng# I have both SC* and LA*. I am sure there are many ways to do so. I was thinking to loop through the rows for the same Eng# and collect the first 2 characters of the Agreement to get to

Eng# ---- Collection
111 --------LA, SC
333--------LA

How can I achieve this? Please help.

Could be done like this:

kn_example_loop_collection.knwf (15.6 KB)

2 Likes

Thank you for your quick response and easy solution! You are the best!

2 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.