Hi All
I have a question about taking a concatenated column in an excel sheet and writing that data to the Notepad application to create a text file.
On the sheet attached, my group pastes in data to the Holdings File tab and ultimately ends up having to copy and paste the concatenation in Column A into a notepad file to upload to an accounting system. I am being tasked with coming up with a way to have this automatically done, and say creating a process that writes only the first 100 rows of data, spits out a txt file, then continues on the next 100 rows and follows this process until all rows have been written to a txt file. This is currently being processed manually where multiple individuals split the work and copy several concatenated rows and manually paste into Notepad. I honestly have no idea how to try to automate this or if that is possible through Alteryx. I'm nowhere near an expert in vba code so that route is difficult for me.
Anyone have any suggestions on how I can even try to attempt doing something like this? Thank you all very much.
