Quote Column Name in Tool

[zqlcancer]

Hi,

I am studying ‘Email’ tool and downloaded a  sample file from community. I noticed in the workflow used ‘Report Text’ tool to create a header and in ‘Text Data’ filed it says [Department:A]. I can see ‘Department’ is the column name of original data but I don’t understand why it adds ‘:A’ behind column name, is this a wild card? Seems to me [Department] is enough. Any advice is much appreciated.

[atcodedog05]

-

[atcodedog05 · Accepted solution]

Hi @zqlcancer 

:A is the format for all strings which means auto and :0 is the format for numeric where 0 is number of decimal points. Only fo double it shows the options for decimal points like below

Workflow:

Hope this helps : )

[zqlcancer]

Thanks for sharing, I did not realize I can select avaialbe fields from drop down list. I manually inputted field name but it seems like the workflow can run without error. i.e. in my case I only inputted [Department].

[atcodedog05]

Happy to help : ) @zqlcancer 

If my response helps please don't forget to mark it as solution.

Cheers and have a nice day!