Data table displaying as string, would like to convert to rows

Help Studio
, , , ,
1

I am extracting data tables from a PDF. So far, I can extract the data table, but when I try to write to excel it will have the separate columns, but it will put all of the data from each column into one row. How do I get the results to write down the rows instead of having only one row?
Thank you!

2

@james.althoff

In your datatable do you have multiple columns?

Can you share some screenshots or more details

Cheers

3

@Anil_G yes multiple columns.

Screenshot 2023-02-09 140235
Screenshot 2023-02-09 1402351640×481 28.6 KB

4

@james.althoff

Can you check in dataTable by using a breakpoint how you are getting the data

cheers

5

@Anil_G I am using an ML Extractor to read unstructured PDF tables. From there
Present Validation Station → Export Extraction Results → For Each (currentItem in datasetResults.Tables) → Append Range Workbook with currentItem

6

@james.althoff

Keep a break point in your for each…open the locals pane and check the datasetresults.Table…if the data is extracted peoperly

Cheers

7

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