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'

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

image

Use lookup activity and pass name.

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

Similarly for another column name.

1 Like


This is what @KarthikByggari is implying.

1 Like