Need Solution - challenge with Extract Datatable

[TAL_TAL]

I am a newbee to UiPath. I wanted to try an exercise using Table Extraction. I used Amazon.com and typed iPhone14 to see the result of the search . It generated 4000 models. I decided to list only 10 models. I could generate the result in an ExtractDT and then write it to an Excel file. But my challenge is that I could not put iPhone14 into a Column Row’ (as a category) to identify that the 10 lines of models (as items of that category) ‘belong’ to iPhone 14 search results.
I also wanted to do the same with a list of smartphone names (Samsung, Oppo, Xiaomi etc) in a ForEach row activity.
Appreciate your guidance. Thank you.

[Harshith_Adyanthaya]

Hi @TAL_TAL,

After Extraction, use add datacolumn and in default value property put Iphone 14.

Since you are working with multiple smartphone names, you can use the variable which you are using to search in Amazon.com as default value for add datacolumn.

Hope this helps.

[TAL_TAL]

Wow, so fast @Harshith_Adyanthaya . Thank you very much. Let me try.

[Steven_McKeering]

Welcome @TAL_TAL to the UiPath Community

Take a look at this Datatable post which has lots of helpful points when working with Datatables

All about Datatable - UiPath

Hi All, Datatable - variable type is the most commonly used variable type by all UiPath users And it’s been the most often asked queries in forum especially on its manipulation So I would like to have this post as a repository for those who are looking for expressions related to Datatable Let’s go one by one keeping dt as name of datatable variable 1. Get number of rows in a datatable dt dt.Rows.Count (output - int32 type) 2. Get number of columns in a datatable dt dt.Columns.Count (output…

Cheers

Steve