Can anyone tell me how to achieve this - by reading the column name ('Amount'), i should get the output as 'F', similarly for i/p 'Name' , it should return me 'B'

[KavithaManohar (Kavitha)]

by reading the column name (‘Amount’), i should get the output as ‘F’, similarly for i/p ‘Name’ , it should return me ‘B’ – refer screenshot

[KarthikByggari]

Use lookup activity and pass name.

The output returns B1.
From the output take only string part.

Similarly for another column name.

[sawaseem (Abdul Waseem Syed)]

This is what @KarthikByggari is implying.