Extract data and transpose help needed!

Help
1

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:

Capture2
Capture21100×136 33.5 KB

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

2

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: Novigo Solutions - Transpose DataTable - RPA Component | UiPath Marketplace

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
3

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.

Capture2
Capture21353×248 71.5 KB

1 Like
4

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

Regards
Shanmukh

5

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
6

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
7

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