Skip to Content
avatar image
Former Member

UDF for changing the counter value based upon source field

we have a requirement wherein the value of counter (standard function which is mapped to target field LINE_NUMBER) to be increment by 1 based upon the source field (SRC_FIELD1) value gets change.

for example source field SRC_FIELD1 has values

ABC

ABC
ABC

DEF
DEF

GHI
GHI

GHI

JKL
JKL

then at target side LINE_NUMBER should have the values as 1,1,1,2,2,3,3,3,4,4

and TARGET_FIELD1 values are ABC,ABC,ABC,DEF,DEF,GHI,GHI,GHI,JKL,JKL (which direct map to SRC_FIELD1)

Can anybody provide the UDF for the above requirement. Points will be rewarded to correct answers.

Regards

Faisal

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers