posted 2 years ago
Hi,
Please help me with the groovy script to look up the values in ID1 column and if it falls under "X" series ID then it needs to set the status "OUT" and copy the value in the Comment column. There are many lines and it needs to iterate and lookup the ID1 value and get the status and Comment column updated. Please let me know if you need any further details.
ID1 ID2 Status Comment
A1 B1 In
A2 B2 In
X3 B3 Out B3
A4 B9 In
X5 B11 Out B11
Thanks,
Vickey