How to Convert string to int32 in Datatable

Help
, ,
1

I am extracting pdf details and write it to one excel file. I want to assign a quantity column as int32 datatype in the build datatable activity. I have to write headers as well in the same data table. But for the quantity column, It only accepts int in headers. I want to write the “Invoice_Quantity” text in that header.
Kindly guide me to fix this issue.
@Palaniyappan @Lahiru.Fernando @lakshman

2 Likes
2

In build datatable change the column data type as “String”.
If your string is of numbers then it can be converted to int type.

3

@Kalees9486 You cannot Convert “Invoice_Quantiity” into Integer as it is not a Number :sweat_smile:
Can you Exclude writing the Headers into the Datatable as i feel you are already providing using Build Datatable Activity?

1 Like
4

The process is; If any items repeat the same we need to group the Item Description with Sum of Quantity. When i assign as String I am not able to sum the quantity values. That’s why I assigned as INT type in the data table.
@Manish540

5

When I exclude the headers, it shows empty headers in the excel file.I want headers in run time itself.
@supermanPunch

6

@Kalees9486 Are the headers already known or is it dynamic?

7

Already Known. When we triggered the BOT the excel files are generated. Means run time itself the headers are added to the excel file.
@supermanPunch

8

@Kalees9486 Can you Exclude the Headers while Extracting :sweat_smile: , since it is already Known, you can Name the headers in Build Datatable as you want

9

The Error was thrown in that Build Datatable only.
@supermanPunch

10

@Kalees9486 Can you show us the Screenshot of the Build Datatable Activity ? Also the Screenshot of the Values that are Extracted if Possible :’

11

I have attached Screenshot of Build Datatable FYI,

Capture

12

@Kalees9486 Why do you want to Add the Header values as row values ?

13

The same as shown in that image.“Inv_Quantity” text.
@supermanPunch

14

You can’t add a string value to a int column in build datatable.

15

@Kalees9486 Can you Remove the First row Added and Check your Workflow? :sweat_smile:

16

I will try. But i need that header.
@supermanPunch

17

Yeah. Any other way to add string headers. Or any suggestion to group the Item Description column?
@Manish540

18

@Kalees9486 Actually Your Build Datatable has Headers with 1 row :sweat_smile:, You need to just Keep the Headers with the Name you want the Headers to be

1 Like
19

Make the column data type as String in build datatable and while using the values use
Sum(int variable) = Sum+Convert.toInt32(row(“ColumnName”).Tostring) to get the sum of that column.

3 Likes
20

And as @supermanPunch Remove the first row.