Use of Calculated Columns

[Former Member]

Hello Everyone !

I need to understand the use of Calculated Columns. In this action we are taking the Source value as a String ang getting the XML output. So can any one please give me a simple example where we can use it and how ?

Regards,

Vaibhav Singhania

[Former Member · Accepted solution]

HI Vaibhav,

Calculated Columns Action block is used for adding a new column in source xml based on some calculation on its columns.

For eg. you have 2 columns in xml as Col1 and Col2.

You can add a Calculated Column of sum of Col1 and Col2

In Configuration of Action block Select your xml file as Document Source .

Define a Sum Column As Col1+Col2

Check the Output of this action block in trace

Thanks

Anshul