Can not assign

[dipon1112000]

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

[Jithesh_R (Jithesh Karkera)]

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)

[dipon1112000]

Hi thank you for helping but it’s there

[dipon1112000]

Can anyone help please

[Jithesh_R (Jithesh Karkera)]

@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,

[dipon1112000]

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

[Jithesh_R (Jithesh Karkera)]

@dipon1112000 ,
Is it possible to share your workflow?

[dipon1112000]

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

[Jithesh_R (Jithesh Karkera)]

@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

Regards,