How to convert variable datatype while getting from Excel

Help
,
21

I just changed from int32 .Because it throws error continuously. @Palaniyappan
But the actual values in decimal also.for example 100.00.

Thank U

1 Like
22

instead of decimal have double buddy and make sure both the table with that column is of type doubleā€¦in order to do thatā€¦
once after converting the column type of the first table to doubleā€¦
use another assign activity to change the column type of the SECOND table as welll

This would work buddy @Kalees9486
cheers

23

It throws an exception again(ā€œmessageā€: ā€œAssign: Exception has been thrown by the target of an invocation.ā€). @Palaniyappan

Thank U

24

does the column that you are trying to convert the type, has any null value along the column
Cheers @Kalees9486

25

Nope. @Palaniyappan

26

@Palaniyappan Still i am facing this same problem. any solution for this problem ??

1 Like
27

let me check once with previous comments buddy @Kalees9486

28

Yeah bro .just now i checked .it throws target exception. @Palaniyappan
I have attached the error log FYR.

Capture

29

Hi @Palaniyappan
Can you please advise how to convert the whole column data type from string to double and my output should be Data table.
i.e., I have DT1, I need to convert data type of column ā€œCā€ in DT1 and get DT2 (data type converted Data table)