Find and replace not workings
- 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 done the below formula but the value I want to appear is not appearing, instead the cells it should be in are blank, what are the possible reasons?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @BillyL14,
By any chance, you can share with us some example of the data?
Actually I found something that might help you. There is a possibility you have a null or blank data in the file that you are using for the replacing.
It will be worth to take a look at the file that you are using for the replace input if this file doesn't have null/blanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @BillyL14 — Is it a part of your recent post?
1st, You need to change the data type to String for the respective incoming anchor(s), you can use Formula or Select tool.
Once you get the output from "Find Replace" then rollback the data type using Formula tool (if you want).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @BillyL14 ,
The first thing I can see is the case insensitive check box. check it. it will ignore characters case.
Hope it makes sense.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @vizAlter
Thanks, I'm not sure what you mean by rollback?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Emil_Kos
Thanks for your help.
I haven't got it to work yet. To be honest I am not sure if I am using the right tool as am not very experienced at Alteryx yet.
I have attached a sample of what I am trying to do. Basically I want the material number in sample 1 to match with the material in sample 2. Then I want the ratio from sample 2 to appear next to the relevant material after joining so that I can then go onto multiply the masses of the relevant materials by the ratio that has been matched. Do you have any advise on how to do that?
Thank you very much
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @BillyL14,
You didn't include any data in the workflow.
You can copy-paste the portion of the data directly into the workflow in order to provide us with a data sample.
It will be pasted as the text input tool.
I think the find and replace tool is a good one for you. Alternatively, you can use the join tool. In the configuration of the join, tool pick the two fields that you are interested in and it should work.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
sorry, these are the inputs
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
