Issue with no data returned in new column added using formula tool
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a workflow where I am trying to incorporate a new column that will bucket data in another column to a different name. I created an expression using the formula tool to add a new column then list in the expression what fields need to be changed to the specified name. For some reason no data is being returned in the new column created. I do have multiple cells that need to be changed to another name, but testing it out with cells that have a particular name to see if I can get it to return the end result I expect to see.
What do I need to do to get the expected results? Also, is there a better tool to use where I don't have to create multiple expressions to create a new name for each cell since my file is very large?
I have attached a screenshot of my workflow and the formula I am using to create the data I want to see.
- Labels:
- Designer Cloud
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@nicnac_1 Make sure that the if condition satisfies the data. if that is true then only you will get data in the new column
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How do I know if the condition satisfies the data? What do I need to check? When I run the workflow I don't get an error message.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@nicnac_1 check the field [91 Hierarchy Level 6 Description] has the value "GLOBAL TRANSACTION SERVICES" if it is there then the new field should populate with "BANKING"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The value "GLOBAL TRANSACTION SERVICES" is in the [91 Hierarchy Level 6 Description] field, but the new field won't populate with Banking. The new field is blank after the workflow has been run. That is why I am not understanding what is happening. Any other thoughts on what could be happening?
