I’m in StudioX.
I have an Excel with 10 columns. I want to filter this Excel based on the Category column.
These categories are repeating in multiple rows.
I want to list of category type in a separate spreadsheet. For example, in this spreadsheet ‘Category’ column, I want the Furniture, Fruits, Electronics, Vegetables, Sweets as entries in separate spreadsheet. The program should read the category column and uniquely identify the category and copy it in a spreadsheet.
How to do this in StudioX ?
Hi @Prinal_C - By using the Create Pivot table, you can get the unique values
Option 2: Using UIAutomation…You can choose Data → Remove Duplicates to get the unique values…
Option 3: Again Using Automation, Choose Advance Filter, you can get the Unique records, and write it to different sheet…
@prasath17 thank you ! when you say 'using UI Automation…" what does it actually mean ? What should I click in StudioX ?
- Using App Recorder…you can try (below is just sample, not complete)
- Use Application/browser activity
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.