Need help in creating a formula for IF Else statement

[jatienza]

Hi Team,

I have this data below and just need a formula like If Else Statement to come up with the Output as shown below. The formula should not limit only to Job_3_value and Job_3_title. It would also allow if there are job_4_value or job_5_value, etc.

Record	Job_1_value	Job_1_title	Job_2_value	Job_1_title	Job_3_value	Job_3_title
A	1	Manager	0		0
B	0		0		1	Instructor
C	0		1	Director	0

Output:

Job Title

Manager

Instructor

Director

Thanks,

Jaime

[Luke_C]

Hi @jatienza 

I wouldn't use an if statement to do this given the variability in how many columns it needs to handle. I'd recommend something like this:

1. Transpose the data (this will handle any new columns in the future)
2. Filter to 'title' records with a value.

You can then update further via a select tool to reduce/rename the columns

[Felipe_Ribeir0]

Hi @jatienza 

One way of doing this

[jatienza]

Hi!

Sorry I think this is the correct raw data. So if the value is 1 then it will get the correct job title. It should allow if there are additional column for job_4_ value, etc.

Record	Job_1_value	Job_1_title	Job_2_value	Job_1_title	Job_3_value	Job_3_title
A	1	Manager	0	Specialist	0	Loan Processor
B	0	Programmer	0	Supervisor	1	Instructor
C	0	CEO	1	Director	0	Supervisor

Output

Job Title

Manager

Instructor

Director

Thanks,

Jaime

[PanPP]

Hi @jatienza 

I have provided a sample WF.

[Luke_C · Accepted solution]

Hi @jatienza 

Here's two ways - one with the make columns tool and one with the multirow formula tool to flag records that have the '1' in the value column.

[Felipe_Ribeir0 · Accepted solution]

Hi @jatienza 

One way of doing this

[jatienza]

Thanks a lot for your help guys...

[binuacs]

@jatienza One way of doing this