community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Error opening table: Microsoft Access Database Engine:

Highlighted
Meteor

Thank you.. It worked. But can you please explain what will the '$' make difference?

 

 

Sr. Data Science Content Engineer
Sr. Data Science Content Engineer

The $ indicates to Excel that you are specifying a sheet and not something else like a named range. The $ ensures that data gets written to the sheet. 

Meteor

Good to know.. Thank you Sydney!

Atom

An absolutely huge thank you! I've been trying so many work arounds to try and pull in specific sheets from files whose complete filepaths are unknown e.g. 

 

Passing string variable to dynamic input

"C:\Placeholder\" +DateTimeFormat([InputDate],%y%m%d)+ "\Example *"

 

using * wildcard as the end of file name unknown (it uses an hour minute second timestamp which is the bane of my existence). Adding |||Targetsheet at the end didn't work but |||Targetsheet$ did! Will look into why later but for now I'm happy with a running workflow so thank you once again!

 

programmermeme2

Labels