"Macro in the filename of Read Database"

yelena_kro

Hi everyone,

 

I want to use macro value (for example, macroName = query_path, macro_value = C:/Files/query1.sql) in the query file name of Read Database operator as that path is dynamic. So I put %{query_path} to the query file. And it does work giving me the following error:

---------------------------

Cannot read file

'C:\Users\myUser\query_path' - please notice it doesn't use macro value, only parsing macro name as a string

---------------------------

If filename starts from C:/ and then we add macro value (for example, query_path = Files/query1.sql), and query file parameter looks like C:/%{query_path } it works.

 

 

However, I need to specify full dynamic path to run my process with no changes on linux and windows.

Could you advise please, how to resolve?

 

PS: I also tried to use eval() and put macro name in "", it didn't help.

 

sgenzer

hello @yelena_kro - good to have you here.  That's a weird one.  I use macros in my filenames  (normal files, not SQL) all the time but I use a Mac.    Have you tried using Generate Macro and creating the whole file path as a new macro with concat?  And is there a reason you're just not creating a database connection with your SQL database and going that route?

Scott