Trying to output a CSV file, then find its size using the Directory tool.
I'm using Block Until tool but it just doesn't work as expected: the Directory tool reads the folder contents before the file is written.
How do I get around this? I've also tried the 'Wait a Second' tools but these have similarly little impact.
hi @CDunhill
if you can your workflow,then i can have a look and maybe able to configure it. i had similar problems in the past but fixed it
Sure - thank you. Please see attached. You may also note I've never been sure how to incorporate the Directory tool into the workflow so I used Append... if there's a better way please let me know!
So - you will see the file the SECOND time you run it as it's already there, but not the first.
Hi @CDunhill
Please see my solution. i have converted to iteration macro solution. basically in the first iteration, it reads directory before a file is exported.
but by the second iteration the file is exported so the directory reads the input. Please let me know if you have any questions.
also please re configure the file locations for export and directory 🙂
Aargh I still don't know how to use macros. I tried (and failed again) the other day, but I think it might have been a compatibility issue.
I'll give this a go tomorrow though - I appreciate your help with this!
Crazy that this can't be done 'sans macro' though, isn't it?
Yeah, I'm sorry - I just don't know how to use macro files. I'm unsure if I'm doing something wrong. I've tried following online tutorials to create or use macros) but I still keep getting stuck.
Sorry for the ignorance, but this is what I'm doing:
I'm using the latest version of Alteryx, updated the other day.
When I try to open the other file you posted, I get "Missing Macros: this file references macros that are missing or inaccessible".
I'm not expecting you to hold my hand through the basics of macro use but if you can see the obvious thing I'm not doing please let me know!
Thank you again.
Chris
hi if you see input should be same in both macro and workflow. same format
and has to be configured for iteration the one i submmited was already however
I will try again with a fresh head tomorrow.