General Discussions

Discuss any topics that are not product-specific here.

can you dynamically add date in calgary database filename?

crburgess
5 - Atom

I have a workflow that is scheduled to run recurring on server and need to have the calgary database output name saved differently so I can compare the files over time.  Can this be done using calgary database tool?

2 REPLIES 2
caltang
17 - Castor
17 - Castor

I'm keen to know this as well. https://knowledge.alteryx.com/index/s/article/How-To-Create-a-Calgary-Database-1583461647831 doesn't really say much about changing the names, but I reckon you should be able to use a Formula tool to write a path and change it dynamically with a field - then output it / reload it, no?

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
crburgess
5 - Atom

I don't think so or at least see how to do this.  Where you can use formula to create an update file path name, I do not see where you can replace or apply to the calgary database file name in the output tool (at least not how you would with the standard output tool for an excel format for example).

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels