Extract data and transpose help needed!

Hi,

I’m extracting data from a web page from this table:
Capture

This is how it looks when I write it to csv:
Capture2
But I need my data to be saved in csv like this:

Please someone help me, I have tried this for a week now and I don’t have a clue anymore

Hello @hemuli,

I have built a custom component for the same you can download it from the UiPath Connect - Marketplace. It will take a datatable as input & provide you the transposed datatable as output.

Link: https://connect.uipath.com/marketplace/components/transpose-datatable9373

Do leave your feedback under the review section or queries if you have any under the questions section.

Hope this helps. Kudos :slight_smile:

Regards,
Nithin

1 Like

Hi, this works quite a nice, thank you :slight_smile:

Actually I still have a one more need for this case. I need to add businessid at the beginning of every row after the transpose. Does anyone have an advice how to do this?

This is a screen show from the data after transposed with the activity and added the highlighted column manually to the csv to demonstrate what I need to achieve still. I do have a variable to where the id is stored but I don’t know how to add it to the first column.

1 Like

@hemuli
You can Use Insert Column activity and in properties give position as 0

Regards
Shanmukh

Hi, thank you :)! this seems to be working. Anyhow I will mark Nithin_P aanswer as a solution because it solved the original question. Thank you for your help and responses!

1 Like

Hello @hemuli,

  1. You can add a Data Coulmn (Business ID) to the Transposed DataTable
  2. Use a for each loop on the Transposed DataTable & Update the Business ID for each row based on some conditions

Hope this helps. Kudos :slight_smile:

Regards,
Nithin

1 Like

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