This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a large workflow with multiple inputs to consolidate and one of those inputs is a .csv file. I'm bringing in using a directory but I'm getting the "too many fields in record" error when I try to import the sheet. Is there a solution that will allow me to use this same flow but remove the delimiter issue? Workflow attached.
Hi @clramsey5045 , are you trying to bring in a mix of files (excel and csv) from the directory? Unfortunately I can't see what the macro is doing in your workflow. In Designer if you click on Options -> Export workflow, it will export your workflow as a packaged file which will include the macro. Alternatively, you could also just attach the macro in this thread like you did with the data.
@clramsey5045 - Without seeing the macro I can only guess, but check your macro's Output Mode. This can be found in the Interface Designer window. If you don't already have it open, you can find it under View / Interface Designer. To find the Output Mode, go to Properties (the wheel/cog icon). You'll probably want you Output Mode set to 'Auto Configure by Name' or Auto Configure by Position'. I've attached a workflow with several samples of bringing in files dynamically. The container labeled '7. Even More Dynamic . . .' may have a macro similar to what you're trying to accomplish. If this does not help, please attach your macro so we can see it, thanks!