I just encountered a weird error. I have an Excel document that I called something like
In Alteryx, on the input, I use a wildcard to say give me as input any file named "*_Lookup.xlsx". Just now, Alteryx came across with an error that it could not access "~$20170328_Lookup.xlsx". I assume that this is a weird hidden file that Excel created but forgot to get rid of.
I was finally able to rename my original file to the name of this weird "~$" file, then got a warning about overwriting that file, and then changed the name back to remove the "~$".
My question is -- will this ever cause a problem with my data loads? This may be more of an Excel question -- but will Excel create a "~$" copy of the my file causing records to show up in duplicate? If so, we may have to start wild-carding on the suffixes. Ex, "Lookup_*.xlsx"