Need to calculate two columns of notepad

[dipon1112000]

Thank you for helping me, ya it’s true but if I just want to divide the value in row 1 under column3 with column5 then can that be done?

By the way how did you get what is there in the data table did u tried read range to get the output?

[vrdabberu (Varunraj)]

Hi @dipon1112000

Please refer the above image

Use the read text file activity and read the entire text file and then use the generate data table activity and generate the data as per the requirement and below are the conditions need to give in the generate data table activity.

Later I have used the Write CSV activity and passed the generated data into the CSV File.

Regards

[dipon1112000]

Thank you so much, just one more doubt how do I do the division as I am getting compiler error, sorry for asking this stupid question

[vrdabberu (Varunraj)]

Hi @dipon1112000

Try the below syntax in Write Line.

(CDbl(Number2)/CDbl(Number1)).ToString

Hope it helps
Regards

[vrdabberu (Varunraj)]

Hi @dipon1112000

Here I have attached the workflow please check
Sequence.xaml (13.3 KB)

Regards

[dipon1112000]

Hi I am able to calculate two columns that I got as an input from notepad but not sure how to extract the output to a new CSV as an additional column as write CSV is pasting the last record only

[lrtetala (Lakshman Reddy)]

Hi @dipon1112000

Check on below post

Unable to extract output of Uipath

Hi @dipon1112000 Try the below process: =>Use Read CSV to red the file and store the output in a datatable. Input: [image] => Use Build Data Table activity to write the columns. Build DataTable: [image] => Use For Each row in DataTable to iterate through each row and give the below syntax in assign activity: Number1= CDbl(CurrentRow("column3").ToString) Number2= CDbl(CurrentRow("Column5").ToString) Output= (Number1/Number2).ToString Note: Number1 and Number2 are of DataType System.Dou…

Cheers!!