In my scenario, after creating a datatable from excel extract I needed to add 4 data columns (L, M, N, O). The values of newly added data columns are calculated from previous columns by applying certain formulas or getting values from web application.
- column L is calculated based on (I-J)*-1. Since I and J columns may have spaces, I am not able to apply the formula. What conversion would be required.
- Column M values(numeric) will be retrieved from web application. This will happen later in workflow. However this value need to be used to calculate column N.
- Column N is calculated L+M. - How should I handle this. values of L is from data table and values of M is from web application ( later in workflow)
- Column O - from web application alpha numeric, not used for any calculation.
Thanks for the help.