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.
Find answers, ask questions, and share expertise about Alteryx Designer.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
My work are very sensitive around what information we share so I can't include a workflow. Its a bit frustrating, I know.
When I "Append to Existing Sheet" I get the following error
Output Data (22) Error opening query: Microsoft JET Database Engine: '' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.\3125 = -537199594
I can get the data in using "Delete Data and Append' or "Overwrite Sheet (Drop)" but not sure how to best deal with extra lines if needed?
Also, my data get converted to strings when I drop the header so had another discussion on using SQL to remove the header after pasting in
Here is (a highly redacted) picture of my output - The red square is the named range
And here is a screenshot of my workflow. Very simple just trying to drop the data into Excel - Range = "Journal_Detail"