Not able to convert Float to Integer

Avatar

Avatar
Validate 1
Level 2
chaitanyavemava
Level 2

Likes

6 likes

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
chaitanyavemava
Level 2

Likes

6 likes

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
chaitanyavemava
Level 2

27-09-2019

Hi,

We are downloading a file from SFTP and Updating data in Adobe Campaign Standard (ACS), here for some fields data in the file is floating the data type in ACS is Integer so while uploading the data that field is updated to '0' say for example the value is file is "123.0" ACS is updating as "0" but I want it to update as "123"

Can someone please help me on this

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back 5
Level 4
prasannakumarmarru
Level 4

Likes

51 likes

Total Posts

59 posts

Correct reply

17 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 10
Give Back
Boost 50
View profile

Avatar
Give Back 5
Level 4
prasannakumarmarru
Level 4

Likes

51 likes

Total Posts

59 posts

Correct reply

17 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 10
Give Back
Boost 50
View profile
prasannakumarmarru
Level 4

27-09-2019

Hi Chaitanya,

Try casting the "source expression" on the update data activity to integer by using advanced functions-

1837912_pastedImage_0.png

1838024_pastedImage_1.png

Hope this helps, Thanks!

Answers (3)

Answers (3)

Avatar

Avatar
Validate 1
Level 2
chaitanyavemava
Level 2

Likes

6 likes

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
chaitanyavemava
Level 2

Likes

6 likes

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
chaitanyavemava
Level 2

10-10-2019

Hi Prasanna,

I am able to convert floating number to integer now

Thanks you for the help

Avatar

Avatar
Give Back 5
Level 4
prasannakumarmarru
Level 4

Likes

51 likes

Total Posts

59 posts

Correct reply

17 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 10
Give Back
Boost 50
View profile

Avatar
Give Back 5
Level 4
prasannakumarmarru
Level 4

Likes

51 likes

Total Posts

59 posts

Correct reply

17 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 10
Give Back
Boost 50
View profile
prasannakumarmarru
Level 4

09-10-2019

Chaitanya,

May I know if you are seeing 125.0 in the transition coming into update data activity(to view data in transition, you have to go to workflow properties and select 'keep interim population' and run the workflow, select the transition and open transition)?

if you are not seeing it, then probably the issue is in data loading activity, could also be an issue with delimiters in the file.

Thanks!

Avatar

Avatar
Validate 1
Level 2
chaitanyavemava
Level 2

Likes

6 likes

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
chaitanyavemava
Level 2

Likes

6 likes

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
chaitanyavemava
Level 2

29-09-2019

Hi Prasanna,

I have tried with ToInteger()but still it is updating as "0".

2.JPG1.JPG