How to rearrange the value-by-[row to value-by-column?

Help Activities
, ,
1

See the attached images below.

valuebyrow
valuebycolumn

Is it possible to rearrange the values of the data table obtained through web data scraping in the column direction as in the image?

What activity should I put after the Extract Structured Data activity in the Flowchart?

2

Hi @greenlee

You can use this custom activity package for transpose the datatable.

Thanks

1 Like
3

@greenlee

Download DataTable activities package from UiPath Market place and install it in studio. And then use Transpose DataTable activity to convert Rows to Columns and Vice versa.

2 Likes
5

You respond very quickly and accurately. It’s like AI.
I’ll give it a try and post the results here.

Thank you so much.

1 Like
6

Good overview contents.

Thank you so much, lakshman.

1 Like
7

Hi @greenlee ,

If you want to write everything from scratch then you can follow below thread.

Thanks

1 Like
8

Hi @prasath_S and @lakshman,

I used your both transposed activities and succeeded them. But When I tried to append the transposed datatable(ExtractDT_clm in this case) to “Case Expression2.csv” I failed. I didn’t know why.

I would be very grateful if you could try the attached project below and let me know the solution.

한식메뉴사전_Case.zip (1.4 MB)

9

Hi @greenlee

What error you are getting?

Also could you share the screenshots of the workflow, because I can’t download the file in my laptop due to restrictions.

Thanks

10

No error message.
The result csv file was not touched.

2021-09-11 133140
2021-09-11 1331401008×783 34.3 KB

11

@greenlee please check the following things,

  1. Drag a output datatable activity and pass the input (output of extract table activity) and store it a string.

Put a message box and check if the data ks scrapped correctly.

  1. After transpose activity activity also do the same logic (input of output datatable activity will be output of transpose datatable activity) and check if the values are coming.

  2. And if everything comes correctly use write range activity and write the datatable to excel instead of append CSV (for testing).

Thanks

12

I passed the upper 2 comments and checked its doing correctly. But I got a blank ‘result.xlsx’

2021-09-11 140040
2021-09-11 1400401001×804 36 KB

13

Where is the Extractdt_clm comes from?
Put a message box before excel application scope and give Extractdt_clm.rows.count.tostring
Thanks

14

I got ‘0.’

15

The excel is blank because the datatable is empty (had 0 rows only).

Could you show the transpose datatable properties panel.

Have you store the output in a variable extractdt_clm

Thanks

16

Options/Addheaders checked in ‘Write Range’ activity gives one row in result.xlsx correctly. I think it recognizes the data of ExtractDT_clm as header.

17

2021-09-11 144427
2021-09-11 1444271025×275 16.3 KB

18

Is your excel had only one column? or it has multiple columns

Thanks

19

multiple one like the below;

2021-09-11 144808
2021-09-11 144808945×64 3.81 KB

20

Is the excel file contains only headers or it has multiple rows in it?

Just now I noticed, you are getting the datatable extractdt from extract datatable activity,so how many rows and columns you are getting in that datatable,

You can check by

Row count Extractdt.rows.count.tostring

Column count
Extractdt.columns.count.tostring

Thanks

21

The result.xlsx shows the sheet like above one, with just one row.