Load data issue with long character

Question

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:

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

And this is the settings for it:

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

imicu · Accepted Answer

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.

ParthaSarathy · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded