Expand my Community achievements bar.

SOLVED

Load data issue with long character

Avatar

Level 3

Hi! Im currently working on a workflow where we will start importing a new file in the database. But Im having a issue when loading the data. It adds "," on the int64 column.

How it looks like in the file:

marting66652718_1-1661343466078.png

 

How it looks like when loading it to adobe campaign application.

marting66652718_0-1661343440218.png

And this is the settings for it:

marting66652718_2-1661343522998.png

 

What do I need to do to remove the "," from the data? So it only will be for example: "123123123123" and not "123,123,123,123"

 

Best,

Martin

1 Accepted Solution

Avatar

Correct answer by
Employee

That is the thousands separator for any integer. The raw data is still the same, but it is displayed with comma separator for better reading. It should not affect your queries or expressions.

 

If you want to send that as invoice ID within the delivery without comma thousands separator, then you can use function ToString(@POLICY_ID)

 

Alternatively, you can also alter the schema and change the element type to string.

View solution in original post

2 Replies

Avatar

Community Advisor

Hi @marting66652718 

I had tried the same, this seems to be the expected format for int64 in data tab.

To display as 123123123156 instead of 123,123,123,156 you can store the value as String

ParthaSarathy_0-1661346683860.png

 

 

Avatar

Correct answer by
Employee

That is the thousands separator for any integer. The raw data is still the same, but it is displayed with comma separator for better reading. It should not affect your queries or expressions.

 

If you want to send that as invoice ID within the delivery without comma thousands separator, then you can use function ToString(@POLICY_ID)

 

Alternatively, you can also alter the schema and change the element type to string.