change data format for multiples files

hi, i have a quick question about change data format for multiples files. Now I have many excel files that have same data format(say one file for each car brand, the only difference is different files have different number of rows). I just need to do some transpose/cross/subtotal functions. I already built a workflow to do it for one file. Is there any way to have alteryx do it for all the files I have? Thanks.

Developer Tools

Preparation

Accepted answers

AngelosPachis

Hi @yc151 ,

Here's an example. I would suggest you also spend some time to go through the macros Interactive lessons if you haven't done that already.

Let me know if you have any further questions.

Cheers,

Angelos

sample_workflow.yxzp

All comments

AngelosPachis

Hi @yc151 ,

Yes, you can create a batch macro to read each one of those files, do the transpose/crosstab/summarize functions (that should be consistent across all files) and then write the output to the same filepath

yc151

Thank you @AngelosPachis , can you share how to write a such macro? or similar macro?

ArtApa

Hi @yc151 - A batch macro can be a good solution for you. You may learn about types of macros in Alteryx and how to design a macro here: https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Macros

However, there is a chance that a Dynamic Input will also do a job for you. You can potentially (must be the same schema) read all your files process them and then Output to one or many files.

a) Please review Dynamic Input sample:

b) Please review Output Data sample:

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703