i need a help for the below
code qty ID
212345 anything 100
14565 kg 1
14564 no 2
if code starts with 2 qty anything that ID should be 100
if code starts with 1 and qty is kg ID should be 1
if code starts with 1 and qty is no ID should be 2
Fine
hope this steps would help you resolve this
βuse a excel application scope and pass the file pathas input
βinside the scope use a READ range activty and get the output with a variable of type datatable namedd dt
βnow use a for each row loop and pass the input as dt
βinside the loop use a assign activity row(2) = if(row(0).ToString.StartsWith(β2β),row(2) = β100β, IF(row(0).ToString.StartsWith(β1β) and row(0).ToString.Equals(βkgβ),row(2) = β1β,row(2) = β2β),string.empty)
the expression will be like this if(row(0).ToString.StartsWith(β2β),β100β, IF(row(0).ToString.StartsWith(β1β) AND row(0).ToString.ToUpper.Equals(βKGβ),β1β,β2β),string.empty)
aah got it
remove the string.empty if(row(0).ToString.StartsWith(β2β),β100β, IF(row(0).ToString.StartsWith(β1β) AND row(0).ToString.ToUpper.Equals(βKGβ),β1β,β2β))