Hi all , am using uipath AI to extract invoice details & i its working fine but the thing is i need to add a new coloumn on it as a Filename by using taxnomy manager 've added the coloumn name but am not getting respective value in that cell , i 've took the file name from directory & holded in variable .
now i want to place that file name in that cell.
Use Build DataTable activity to create DataTable and then use Add DataRow activity to add data to DataTable and then finally use Write Range activity to write into Excel file.
Pass Array Row value as below in Add DataRow activity.
Hi
If we have added the new column and if our intention is to add a new value to that column, may I know why do we need the value of that cell as anyhow we are going to assign it with a New Value
Then to assign value it is best to go with ASSIGN or ADD DATAROW activity or WRITE CELL activity if we are trying to assign a value to a single cell
Because Build datatable activity can be used and can be entered with value while creation itself but every time it creates a new Datatable when used
So that will be a problem when data added at multiple places
So with ASSIGN activity we can mention like this if we are known with the cell position Datatable.Rows(rowindex)(columnindex) = “your value”
Where both rowindex and columnindex starts from 0 for first row and first column
Or with WRITE CELL activity
We can mention the cell position as “L2” and the value as string input
So what this does is for each time when a row is added without any value for that specific column in the datatable this assign activity will place that value to that cell
Cheers @naveen19
I am just Testing it out Invoice ai …iam not getting the point for every run it is asking me for validatin … Can some one please help me on this @naveen19@Palaniyappan]
I am trying to extract the invoice fields and had workflow given by uipath . running it . when i am running the workflow it is going for validation sation. For first time i obeyed with concept of training the bot But for second time Also …it is going for validation station …Not getting this how many times i have to train the bot
hi @Vijay_RPA ur using DataExtraction - ML Extractor - Demo - Copy.zip (229.8 KB) which ur downloaded by uipath assist right !
so it will ask us to validate the extracted data
if ur implementing this code in your project it wont ask to validate it directly extract value so dont worry Hope u got my point.