Assign problem!

[Happydayyy (22035153d)]

I need to assign the data of “sample ID” as a variable, but it come to this problem, may I ask how I can cope with this?

[mkankatala (Mahesh Kankatala)]

Hi @Happydayyy

Change the AppNum Variable to the System.Double datatype in the variables panel.

Hope it helps!!

[Happydayyy (22035153d)]

seems there is not have this

[mkankatala (Mahesh Kankatala)]

Type system.Double in the Serach bar then you will find that datatype, click on Double… @Happydayyy

Check the below image for better understanding,

Hope you understand!!

[Happydayyy (22035153d)]

there is still have an error…

[Happydayyy (22035153d)]

FA Sorting AFTER confi…xaml (41.6 KB)
U can have a look on my workflow… Many thanks

[mkankatala (Mahesh Kankatala)]

In the workflow you have deleted the assign activity where you are getting error… @Happydayyy

I Inserted the assign activity in the same place and updated the datatype of AppNum variable to System.Double. Give the expression in the value field of assign activity and try weather it was giving the same error or not.

Here is the updated workflow,
FA Sorting AFTER confi…xaml (41.3 KB)

Hope you understand!!

[Happydayyy (22035153d)]

FA Sorting AFTER confi. (3).xaml (41.8 KB)

I dont know why there is still have the mistake…

[mkankatala (Mahesh Kankatala)]

Change the Value expression in the assign activity… @Happydayyy

- Assign -> AppNum = dtSummary.AsEnumerable().Select(Function(row) row.Field(Of Double)("sample ID")).FirstOrDefault()

Hope you understand!!

[Happydayyy (22035153d)]

In the nearly end part of workflow, this error is happen…

[mkankatala (Mahesh Kankatala)]

Okay @Happydayyy

Change as below in the Save as file field,

Completed+"\"+AppNum.toString+"FA_Control_robot"

Hope it helps!!

[Happydayyy (22035153d)]

Thank you so much, the problem is solved!!!

[mkankatala (Mahesh Kankatala)]

It’s my pleasure… @Happydayyy

Happy Automation!!

[Happydayyy (22035153d)]

@mkankatala Hello, Can you go to How to solve this problem? to help me? This seems like a similar issue. Thanks you!!