Forum Discussion

PieterDR's avatar
PieterDR
New Contributor II
2 years ago

Sum two columns in a datasource

Hi all,  In my delimited upload file (trail balance) there are two columns that include amounts: beginning balance and the sum of periodic movements. The sum of the two is the number I want uploade...
Import
Transformation
  • ChristianW's avatar
    ChristianW
    2 years ago

    You will find samples in Snippets:

    If snippets are not available with your installation, you can find them on the solution exchange. An administrator needs to install them for you and then they will be available on all applications.

    Of cause, you need to summ the columns instead of concatenating them.

PieterDR's avatar
PieterDR
New Contributor II

Thanks, I was thinking towards that direction myself as well. I have very basic knowledge of VBA: any chance you could help me with the code?

ChristianW's avatar
ChristianW
Valued Contributor
2 years ago

You will find samples in Snippets:

If snippets are not available with your installation, you can find them on the solution exchange. An administrator needs to install them for you and then they will be available on all applications.

Of cause, you need to summ the columns instead of concatenating them.