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?
Solved! Go to Solution.
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?
You can have the same value in multiple columns. Are you able to upload your workflow and/or a sample of the data you're working with? Based on the screenshot, I can't see the syntax of the formula you're updating with.
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.
Hi echoung1,
I was pulled into a meeting.
I asked one of the other developers and he said he would get back to me.
I'll ping you later if I don't get a response from my coworker.
Thanks again!
HI again echoung1...
You were absolutely correct. In my formula I assigning values that were null. Thanks for pointing that out. I will mark your response as resolved.
Thank you again and warm regards!