The following error was raised by the Export SQL to Excel function: Name is insufficiently unique

Try with this for generating the value and test again please.

a!localVariables(
local!data: split(tostring(rand()), "."),
tointeger(local!data[2])
)

 Tried this logic too. Saved it in process variable and appended it in "Document_name_to_create" attribute as "Doc name " & pv!docName.

Didn't work. Same error.

Honstely by now I think we've ruled out the filename itself being the cause of this error.

Any chance you could try out the equivalent smart service either from the main Excel Tools plug-in, or from the newer stand-alone "SQL to Excel" plug-in (assuming this isn't the one you're already using), and see if the same issue happens?

"Document Name " & now() & "_" & milli()

 Try using this.

Are you sure that you are using that name when generating the document? Maybe you are using a different variable?

Hi Ashwini,

Can you check again if all the columns of your SQL and Excel headers are unique? Also, if you are using cell_keys, check that as well.

Found the root cause here. The document name in a constant that was fetched by Copy Document Service node and the one fetched in Edit Document Properties node in case the document already exists - the document name is the same in both cases. That is why this error comes up on Export SQL to Excel node.

So this was the data issue.

Hi ashwini.nemade 

As I am also facing the same issue, just trying to understand if the resolution is applicable in my case too. The node property is same as is attached by you in this thread. But I am not using the edit document node.

Apologies, I am new to Appian so trying to understand if I am missing something.