how to pick the value/data from a given column name instead of an actual value

[abhishekbiwal]

Hello experts, 

the requirement i have is a little weird, to avoid re-type the data in excel file, the client is going to provide us with column name instead of actual values.

for example

S1     F1     S2    F2     Winner

AA     23     AA    22     F2

AA     45     BB    11     F1

BB     44     AA    32     F2

BB     67     BB    89     F2

here source one S1, field one F1 and similarly source two field two and the winner field will have column name F1 or F2.

So i need to pick the value/data from winner field based on the column name present in the winner field.

my output should

Winner     F1      F2     F3

22            abc    def     a1b2

45            aaa    e4r     a45g

32            wer    ert5    asd4

89             qwe   123    qase

Hope this is clear,

[former_member190674 · Accepted solution]

ifthenelse function should help you in this regard. Find below:

Please let me know if I misread your requirement.

[abhishekbiwal · Accepted solution]

Hello Santhosh,

thats correct, have used IfThenElse condition, to achieve the result.

Thanks for the reply

regards,

Abhishek