Equivalent of an excel "if & match"
- 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
Hello All - New user, not sure the best way to do the below, have tried join, merge but not getting very far...
I have 2 CSV files. The first file has all my data. The second file has 1 tab with a list in column A.
What would be the best way for me to import the 2 files and then do the equivalent of an excel "if & match" function.
i.e. if a cell in column A from file 1 matches any cell from the list in file 2 column A (tab 1) then return a specific name (Say "Identified") in file 1 (say column D)
Hopefully hat makes sense
Thanks
Solved! Go to Solution.
- Labels:
- Input
- Join
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
https://help.alteryx.com/10.6/index.htm#FindReplace.htm?Highlight=Find%20replace
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That is works really well. Within the Find and Replace tool anyway I can get the appended column to display a certain text when it matches? or do I need to do this through the formula tool?
Thanks again.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
IIF(IsNull([Appended_Fieldname],"No Match", "Match")
Yes, a formula with an expression like the one above will do the trick. You'll then want to have a select to de-select the appended column.
Happy Turkey,
Mark
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
