Unable to Translate alias in Macro-- "action tools - Error" & "Dynamic input tool"

[Subhash_Pilla]

Hi all,

I am using a macro to collect row count of specific with a where clause records,  Using a gallery connection

 

Case 1: I am getting error - Unable to translate alias 

                              when i use a input tool with interface action tool to update the table name and update the where clause parameter by using replace string. Its throwing me an unable to translate alias

 

Case 2: Working with Dynamic input tool

                              when i use a dynamic input tool and pass the table name & Where clause parameter as input macro parameters. And used sql update clause instead of replace string. its working in this way nothing has been changed. Added scree shots for the same

Thanks for your support,

regards Subhash 

[mceleavey]

Hi @Subhash_Pilla ,

without seeing your data I'm going to make an assumption and say the alias is not failing for the name of the table you are overwriting but for the alias you are using in the connection string for "aka:dummy".

Can you confirm this is working when you simply try to connect and only give the error when you are dynamically overwriting elements of the SQL clause?

M.