How do I convert this excel formula into Alteryx: =IFERROR(VLOOKUP(E2,'K:\Reports\Template
- 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
How do I create/ transform this column in Alteryx.
=IFERROR(VLOOKUP(E2,'K:\Reports\Templated reports\[Task Report - Active Template.xlsx]RR and OFF'!$A:$E,5,FALSE),VLOOKUP(E2,'K:\Reports\Templated reports\[Task List Report - Completed Template.xlsx]RR and OFF'!$A:$E,5,FALSE))
Solved! Go to Solution.
- Labels:
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Would it be acceptable to output as .xlsx, appending or replacing you records to/in a mapped range while still retaining your formula in adjacent column cells?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes.
I want this formula in a calculated new column. I have to create similar 15 new columns on the automation process.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
yes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It will be easier to give a more precise answer with sample data from the reports, but the reports can be brought into an Alteryx workflow and the correct fields (columns) can be compared using a Join tools. The data in column E from the first report (where cell E2 is located) is first compared to column A of the Active Template and the J output shows the data from the Active Template in column E; then the data that wasn't found in the Active Template (L output of first Join tool) is compared using the same process in the second Join tool. The data is then Unioned together. I added the RecordID, Sort and Select tools to show how the data could be brought back into its original order.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Great help.
