HLOOKUP
- 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
1. The screen shot is my data set
2. The column "schedule 1 type" is a IIF formula IIF(IsEmpty([Stage 1 DataLens Trade ID matched]),IIF(IsEmpty([Stage 2
Business mapping]),[Stage 3 Assumption based],[Stage 2 Business mapping]),[Stage 1 DataLens Trade ID matched])
3. In column "stage" I want a formula which brings out which column did the "schedule 1 type" come from was it stage 1, stage 2 or stage 3.
In excel I had to do this manually. Is there a way in Alteryx to build this "stage" column in?
Solved! Go to Solution.
- Labels:
- Error Message
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
checking
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks. This worked. In my input data I have more fields that you had. At which point do I bring those out so its appears in the output? When I added your workflow it removed the other fields and only kept 5 columns (sch1, type, stages1-3). Thanks
- « Previous
-
- 1
- 2
- Next »