How to fill the value of one column to another column

[VaishnaviGinni]

Input file

Basecode2	Base Code Grand Total
<3 Months (This has string data type)	123456 (this has fixed decimal data type)

Output file

Basecode2	Base Code Grand Total
123456	123456

Please suggest do I need to change the data type

[gabrielvilella]

You can use a formula tool.

[ShankerV]

Hi @VaishnaviGinni 

You can do this in many ways.

One method is:

Many thanks
Shanker V

[ShankerV · Accepted solution]

Hi @VaishnaviGinni 

Another way to achieve the solution is below \

Many thanks

Shanker V

[VaishnaviGinni]

Hi,

Thanks it is working.

Regards

Reeta

[ShankerV]

@VaishnaviGinni 

Welcome, glad that we were able to help you.

Many thanks

Shanker V