Extract datatable from table extraction datatable

Help Studio
1

Hi there,

I am using studio. I extract a pdf using table extraction. However i wan to get A9:I18 into another table without writing and reading from an excel.

2

If you have the data extracted already using table extraction then just refer to the extracted datatable row and column that corresponds to your A9:I18

3

Hi @mark_rajkumar1

You want to get the range of data in a datatable. Am I right?

4

Hi @mkankatala yes i wan to get this range out separately from table extraction.

5

Can you try the below LINQ Expression in Assign activity,

- Assign -> dt_Input = dt_Input.DefaultView.ToTable(false, dt_Input.Columns.Cast(Of DataColumn).Take(9).Select(Function(col) col.ColumnName).ToArray())

- Assign -> dt_Output = dt_Input.asenumerable.Skip(8).Take(10).Copytodatatable()

The range A9:I18 stores in dt_Output datatable variable.

Hope it helps!!

6

Hi @mkankatala may i know what will be the variable type be

7

dt_Input is the variable where you stored the input datatable… @mark_rajkumar1

dt_Output is the datatable datatype variable which stores the output datatable after LINQ expressions. Means it stores the range from A9:I18 data.

Hope you understand!!

8

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