Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to split a file into several files by macro tool? Please help

LeiCheng
8 - Asteroid
yesterday

Hi, Can someone solve this question? I have a file as attached, and want to split it by full name or Chinese name，ensure that there are no duplicate contents in each field of full name or Chinese name. Acutally I have no idea of how many times of  the duplicates will be before I get the real file, so I guess may need Macro tool to solve this problem, but have idea how to set the macro. I attached the input and wanted output (the output should be 5 excel files). Thanks.

 

input:

LeiCheng_2-1759025220647.png

 

 

outputs:

LeiCheng_0-1759025119542.png

 

Preview file
10 KB
Preview file
11 KB
Labels:
Reply
0 Likes
0 REPLIES 0
Copilot AMA
License admin COmmunity Live
Labels
Top Solution Authors
View All