Can you provide a dataset?
I think you will have to isolate these two and then append then, but with a dataset I can do it for you!
can you help me with an example through text input or an example dataset?
because i wont be able to download the dataset
Hi, Thanks
but what if this process is repeating mulitple times in the same excel.
I mean I have taken a wild card input for 20 csv files in single excel and evry file contains different account number
so i want these account numbers to be aligned for all 20 files.
hi @Tid14
Can you clarify "a wild card input for 20 csv files in single excel"?
Do you mean that
a) you have 20 different files that have the same format and you want to process them the same way?
Or b) you mean something else?
If your use case is (a) then you can get it done via a batch macro to process all files that exist in a specified folder. Check out this very useful thread on how to read multiple files: https://community.alteryx.com/t5/Engine-Works/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-ALL-Exc...
Dawn.
@Tid14 Here's an updated version that will work for multiple files. I've created both file IDs and row IDs, you might already have a different way to identify the files.