Quote Column Name in Tool

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.

Accepted answers

atcodedog05

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 : )

report text tool.yxmd

All comments

atcodedog05

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 : )

report text tool.yxmd

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].

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703