Splitting a datacolumn from a datatable into the correct columns

Learning Hub Academy Feedback
1

Used datascraping to extract a table.
howeverm it only managed to extract everything in a column only.
How should i split them into the respective columns?

e.g.
the actual DT in the web:

No.|Name|Age|Address|ID
1 |Aly |23| asdasd | 123
2 |Ady|24|asdads | 456

but data scrap only managed to extract:
No.
Name
Age
Address
ID
1
2
Aly
Ady
23
24
asdasd
asdads
123
456

is there any way i can convert the extracted to the desired dt?

2

Hi,

If you selected “Yes” the following question, can you try to select “No” then choose columns one by one?

image

If the above doesn’t work, it may be necessary to translate it to proper schema using some logic.

Regards,

3

Hi, the above question did not pop up.

4

Hi,

How about to indicate element without header? Can you share screenshot of the original table and information for these element by UiExplore etc?

Regards,

5

Hi, i cant share the UI, but there was no way to extract the table, the only way im able to extarct is the outcome only with 1 column(all other column’s data squeezed into 1). but what about if we extract as 1 column then use some logic to split it?

6

Hi,

How about the following sample?

image
image742×2215 61.6 KB

Sequence.xaml (12.1 KB)

Regards,

7

@TyraS

Please check the sample here…if there are 5 columns you can use directly else change the number 5 in the code to whatever column numbers you have

Output:
image

image
image1012×732 26 KB

Used generate datatable with column separator as Newline and row separator as comma after using regex to replace commas where needed

image
image1101×603 25.3 KB

Sequence7.xaml (9.2 KB)

Hope this helps

cheers

8

hi, i cant open the xaml file. It says invalid document

9

hi, i tried to run, the output is the same, only 1 column

10

@TyraS

Please try this

BlankProcess - Copy (5).zip (5.5 KB)

check sequence7.xaml in this

cheers

11

Hi,

Did you try the above sample as it is? Or modified it for your data?

If possible, can you share your datatable as xlsx using WriteRangeWorkbook activity?

Regards,

12

hi, yes using the sample as it is

13

Hi,

The above workflow outputs the following workbook named result.xlsx. Can you check this?

image

Regards,

14

not sure what’s the issue, but when run the program, there is no error, yet the excel is empty.

15

Hi,

Can you try the following project? (I uploaded the whole project.)

Sample20230703-2aL.zip (3.1 KB)

Regards,

16

@TyraS

Did you happen to try the above sample?

cheers

17

hi somehow i tried debug and it works. what if, there may be different no of rows/columns in the future? i just need to change the 5 to the new number of columns, but for rows? no. of columns would rarely change, but the rows tends to be different most of the times.

18

its still unable to open due to invalid document. but i realised that the output is different from what i need.

19

Hi,

In the above sample, number of row of result datatable is calculated from number of columns : 5 and total rows. So, this assumes there is no empty cell in the result datatable.

Regards,

20

@TyraS

You can use “Generate Data Table from Text” Activity. In which you can pass your string Variable which contains Data Table data and use seprator as New Line. Save the Output in the new Variable of type Datatable.

Hope this will work!