Can not assign

Help Studio
1

Hi I am facing issue with working script. I am getting an error
"Multiple assign can not assign expectedanswer=Cdbl(CurrentRow(“TaxAmount”).ToString

i am using

  1. For Each row in Data Table (dt1)
  2. Assign – row_index=dt1.Rows.IndexOf(CurrentRow)
  3. If – Condition row_index=0 then Continue
  4. Multiple Assign
    multiplier1=Cdbl(dt1.Rows(row_index-1)(“TaxAmount”).ToString
    expectedanswer=Cdbl(CurrentRow(“TaxAmount”).ToString
    multiplier2=multiplier1*default_value_FF5

note multiplier1 is Double, multiplier2 is Generic Value, expectedanswer is Double, and default_value_FF5 is Double which has default value 0.05
inputsheet1.txt (1.5 KB)
inputsheet2.txt (596 Bytes)

can anyone help please

2

Hi @dipon1112000 ,
I believe there is a “)” missing in your expression

Try this
expectedanswer=Cdbl(CurrentRow(“TaxAmount”).ToString)

(Assuming that the expectedanswer is a variable of type double)

3

Hi thank you for helping but it’s there

17098785630358311088616770087582
170987856303583110886167700875821920×1440 374 KB

5

Can anyone help :pray: please

6

@dipon1112000 ,
I can see Multiplier2 is a variable of type generic value.Could you please show what you have initialized there?
Or try this

multiplier2 = CType("Whatever expression currently there",GenericValue)

Regards,

7

I think the issue is with row 15, 16, 33, 34 in the input sheet 1

These rows do not have data

But I don’t know how to remove them through automation as it is getting generated in the output of another flow.

I tried using remove data row after read CSV but it’s removing only 1 row and not all.

If these rows can be removed them the script will work

multiplier2 is format value

17098834058746867789277967013750
170988340587468677892779670137501920×1440 328 KB

8

@dipon1112000 ,
Is it possible to share your workflow?

9

Thank you for helping but I cannot share the work flow as it is in rdc but if you can help me in removing the rows with no data then it’s going to work

10

@dipon1112000 ,
If you want to remove the rows that has empty values then you can use "Filter data table " activity before you use for each row in data table activity and filter the rows

image

image
image810×569 28 KB

Regards,