how to convert stringtype to int type in adf using variables

Question

how to convert stringtype to int type in adf using variables

Akhil 21

how to convert stringtype to int type in adf using variables , I have validate the rowcount before doing the copy activity

Brown, Jason 25 Reputation points

2023-07-21T18:50:02.8466667+00:00

Or, you know... and I realize this is completely ridiculous... but Microsoft could allow numeric data types for variables. I KNOW, I KNOW.. it's only 2023 so we're not quite there yet. But either be strongly typed and allow integers, etc., or be weakly typed and provide auto casting of data types.

2 answers

Your answer

Brown, Jason 25 Reputation points

2023-07-21T18:50:02.8466667+00:00

Or, you know... and I realize this is completely ridiculous... but Microsoft could allow numeric data types for variables. I KNOW, I KNOW.. it's only 2023 so we're not quite there yet. But either be strongly typed and allow integers, etc., or be weakly typed and provide auto casting of data types.

Answer 1

ShaikMaheer-MSFT 38,546 Microsoft Employee Moderator

Thanks @Michael Taylor for helping here.

Hi @Akhil , Thanks for posting query in Microsoft Q&A Platform. The above function toInteger() shared by @Michael Taylor will be used in Mapping data flows. If you are looking for converting string type value into integer type inside Pipeline expressions then use int() function.

Click here to know more about int() function.

Hope this helps. Please let us know if any further queries.

------------------

Please consider hitting Accept Answer button. Accepted answers help community as well.

Akhil 21 Reputation points

2022-04-13T10:38:30.72+00:00

Hi @ShaikMaheer-MSFT , Thanks for the explanation , I am trying to assign int value to a variable but we can have only string , boolean , array type in variable , even if i use the conversion function int i cannot assign it to a variable as there is mismatch in the datatype.
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2022-04-13T10:43:51.17+00:00
Hi @Akhil , Yes in ADF currently it supports only below type of variables.

String

Boolen

Array

Any specific reason to have variable with int type?
Please note, you can have string type variable only and when ever there is a need to convert in to integer, there use int() function.

-----------

Please consider hitting Accept Answer button. Accepted answers help community as well.
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2022-04-20T15:29:35.717+00:00

Hi @Akhil ,

Just checking in to see if the above answer helped. If this answers your query, do click and upvote for the same. And, if you have any further query do let us know.

Answer 2

Michael Taylor 60,161

Rowcount should already be an integral value. But let's assume you have an existing string and want to convert it. You'll use the toInteger or toLong functions.

   toInteger(rowCountAsString)

Share via

how to convert stringtype to int type in adf using variables

2 answers

Your answer