Nested data table

Help
, , ,
21

yes my inner table is the invoice detail table as highlighted by you

22

Ah.When your website structure is like that in the excel we can use the data scraping and the return value is Datatable variable. Can you try to use the DataScraping in your website and send it to me the value that you get. Thank you

cheers :smiley:

Happy learning :smiley:

1 Like
23

@pattyricarte
Sorry I couldnt reply due to restriction on number of replies a new user can create.

yes i am using data scrapping and getting the invoice detail in data variable and than this data variable i am writing in the customerInvoiceListTable as the second column (making it as inner table). Reading from website and then writing in the outer table is achieved. The problem is to read the inner table back from the outer table. it will help if you can give me xaml to read the inner table

by send the value to you . what do you mean? how do i send and what?

My problem statement againā€¦
I have a DataTable with 2 columns, the first column is of type String(ā€œcustomenameā€) and second column is of type DataTable(ā€œinvoicetableā€).
To retrieve the data i am using For Each Row.
I am able to get the value for first column as its string.
:::::::::: row(ā€œcustomenameā€).ToString
However, I am not able to retrieve data from the second column as it is a datatable. I do not know how to type cast it to Datatable. the below gives an object and now to use this object i need to convert it to a DataTabel object. I do not know how to do this type casting. Please advise on type casting, is it possible in Ui Path or its not and some workaround has to be implemented.
::::::::: row(ā€œinvoicetableā€).???

24

Hi @msk,
Yes, you can access the nested datatable from a particular cell(i.e cell which contains datatable).
How?
By converting that cell into datatable using below expression,
dt_Cell = CType(dt_Nested.Rows(0)(1),DataTable)

Where,index 0 & 1 means second cell of first row.

Iā€™m attaching the workflow for your reference. AccesingNestedDataTable.xaml (9.9 KB)

Please mark it as solution, if it helped you.

1 Like
25

@sharique.khan This is exactly what I was looking for. Now I learned how to change the type of object. Thanks

2 Likes
26

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.