I am unable to convert the Integer to Data table coloumn

Help Studio
, ,
1

Hi Team,

Please Check and Give any Solution for this
Thanks

image
image751×245 11.5 KB

2

HI @vr10

Give the variable in the column name field if it is a column header
image

If it is a value use default value property to update column values

image
image1333×364 32 KB

Regards
Sudharsan

3

Hey

in this activity you should provide the dataColumn variable with all the data or provide the name as string variable

if you want to retrieve your column name as string using your index just use this code

yourDTVar.Columns(intIndexVar).ColumnName

image

Regards

4

Hi,

Thanks for reply

Data in Security_Quantity its Integer
I have to add this data to Existing Excle .
Where I have to Mention Security_Quantity and How

Security_Quantity is Variable (Stored in Data)

Thanks

5

Hey

there are many options to add your data, but going directly please share an exampled expected output, so we can help you better, provide input and output samples

Regards

6

@vr10

You will have that extra column in the excel ?

if yes you can do like this

  • Read Range and store them in the Dt variable
  • For each row in datatable
    • Assign activity and in
      Left → Row(“Column Name”)
      Right-> Security_Quantity
  • After for each keep a write range and write them in a excel and the column will be get updated

Regards
Sudharsan

8

Hi @vr10 ,

Could you also provide us with the Expected Output Data as provided the Screenshot for the Input data ?

In this way, we would be able to suggest the right approach.