I am trying to insert the same string value into two adjoining columns. Like so: Nameemployee numberRoleTitleJohn Smith12345AnalystAnalystJane Doe67890LeaderManagerBob Grant45678EngineerSenior Engineer How do I force text into Role and Title of Analyst for John Smith in first row?

Duplicate String value in two columns

I am trying to insert the same string value into two adjoining columns. Like so:

Name	employee number	Role	Title
John Smith	12345	Analyst	Analyst
Jane Doe	67890	Leader	Manager
Bob Grant	45678	Engineer	Senior Engineer

How do I force text into Role and Title of Analyst for John Smith in first row?

Accepted answers

echuong1

Can you write the data coming in from Salesforce to an excel file and upload that? You have multiple Salesforce inputs, and I think the error is coming from the formula tool at the end. I really just need the data coming out of the Sort tool (highlighted below).

With regard to the values being null in your last screenshot, one of the formulas that has a null output is probably overwritting the values.

All comments

echuong1

If I understand your question, you can use a formula tool to isolate the row with conditional statements then update the values where needed.

New Workflow1.yxmd

JAF

Thank echuong1...

I tried the same thing but I get Null in the second field. Like two identical values are not allowed:

Dave Harvey should be in both columns but I get a [Null] on the second column. Could it be my Alteryx version?

Quick Links

This months top contributors

AkimasaKajitani 388

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335