For the below data - I'd like to use a filter or formula for the input data and have the desired output:
(Please note the the values in browser/application columns may be (alphanumeric with special characters)
Input
Issues | browser/application | Owner |
1 | Chrome | |
2 | FireFox | mozilla |
3 | Edge | microsoft |
4 | IE | Microsoft |
5 | powerapps | microsoft |
6 | drive | |
7 | safari | apple |
Output
Issues | browser/application | Owner |
1 | Chrome | |
2 | FireFox | mozilla |
5 | powerapps | microsoft |
6 | drive | |
7 | safari | apple |
Once the above is achieved I'd like to output the data into separate worksheets - an example below:
Worksheet 1
Issues | browser/application | Owner |
3 | Edge | microsoft |
4 | IE | Microsoft |
5 | powerapps | microsoft |
Worksheet 2
Issues | browser/application | Owner |
1 | Chrome | |
6 | drive |
Solved! Go to Solution.
@geeklarokcmie Just filter out the fields that you don't want then use the output tool and configure like the attached workflow
Appreciate your response.
However, the input data has various values in applications/systems column and only three owners tied to various applications (ex: Jane Doe, John Doe, Jill Doe).
I want the desired output to have all the three owners along with only specific applications from John Doe. How is that achieved?
Also, how can I export the data based on a value in column to different worksheets?
@geeklarokcmie use a formula tool with file path of where you want it saved filepath/ + [owner(or other field you want to split into) ] + .xlsx|||sheet1
And then use the output tool saying get filepath from field
Appreciate your response.
But the formula tool is requiring an output column? And when I add the below formula it runs into the error :
filepath//C:\Users\JohnDoe\OneDrive - AE\Pro - T\SN + [owner(apple)]+ .xlsx|||sheet1
ErrorLink: Formula (5): https://community.alteryx.com/t5/*/*/ta-p/741733?utm_source=designer&utm_medium=resultsgrid|Parse Error at char(0): Unknown variable "filepath" (Expression #1)
create a new field and call it filepath or anything you fancy
@geeklarokcmie Can you provide a sample file with your expected result?
INPUT:
Number | Application | Group | Owner |
1 | Chrome - Production | John Doe | |
2 | Edge | Microsoft | Jill Doe |
3 | Iphone - Production | Apple | Jill Doe |
4 | Drive - Production | John Doe | |
5 | PowerApps | Microsoft | John Doe |
6 | FireFox | Mozilla | Jane Doe |
7 | Safari | Apple | Jane Doe |
8 | TikTok | TikTok | Jane Doe |
9 | Jane Doe | ||
10 | SnapChat-Model | SnapChat | John Doe |
I'd like to output a result based on the above input - when the owner is John Doe but the applications does not contain the following values "Chrome", "Drive" and "SnapChat"
OutPut:
Number | Application | Group | Owner |
2 | Edge | Microsoft | Jill Doe |
3 | Iphone - Production | Apple | Jill Doe |
5 | PowerApps | Microsoft | John Doe |
6 | FireFox | Mozilla | Jane Doe |
7 | Safari | Apple | Jane Doe |
8 | TikTok | TikTok | Jane Doe |
9 | Jane Doe |
Then, I'd like to export the output based on the group into same worksheets on the excel workbook:
Sheet1:
Number | Application | Group | Owner |
2 | Edge | Microsoft | Jill Doe |
5 | PowerApps | Microsoft | John Doe |
Sheet2:
Number | Application | Group | Owner |
3 | Iphone - Production | Apple | Jill Doe |
7 | Safari | Apple | Jane Doe |
@geeklarokcmie I put all the sheets in one Excel workbook