Multi field based calculation

Hi all,

I want to calculate new column based on existing columns, for example i hv columns

Col1,col2,col3,col4,col5,col6.......

New col calculation criteria matching with col1 value then i need to pick value from col4, same with col2 then col5 and so on, is this possible through multi field tool ?

Can anyone help ?

Output

Accepted answers

unknown

Thanks @OllieClarke this worked for me.

All comments

OllieClarke

Hi @Inactive User you could use a normal formula tool for this, but a better approach (I think) is to use a record ID and a transpose tool (using recordID and Col1 as your key fields). You can then filter to where [Value]=[Col1] and join it back onto your data using the RecordID.

Hope that helps,

Ollie

unknown

Hi @OllieClarke

Thanks for your revert, i am sharing a sample data set and snapshot, I have 40 column of Morning, Day and want to calculate 40 columns of Afternoon with a formula (can check in afternoon columns), Can you help to resolve this issue ?

Sample Data Set.xlsx

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703