Output

Hi All,

I have an output written into an excel file as indicated in example 1. I have the below two questions

1) Is there a way to add comma to the numbers automatically based on number of digits under the date column(eg: 28,843)?

2) Next time when I run the same workflow, I want only the date column appended to the right with the next run date as indicated in second example. When I try to append the output to existing file, both columns(inspection and date) get added to the bottom of existing one. Not sure if there is a way to append only one column(date) to the right of the existing one.

Any help would be appreciated. Thank you in advance!

Example 1:

Inspection	11/10/2020
Discovery Data Firm CRD/Branch ID validated	28843
Firm CRD & CRD Number mismatch validated	25070
Firm CRD validated	29063

Example 2:

Inspection	11/10/2020	11/11/2020	11/12/2020
Discovery Data Firm CRD/Branch ID validated	28843	28843	28843
Firm CRD & CRD Number mismatch validated	25070	25070	25070
Firm CRD validated	29063	29063	29063

Output

Accepted answers

philipmannering

Does this help?

Workflow.yxmd

All comments

philipmannering

Question 1)

Best way is to use a formula tool with the formula,

ToString([Field1], 0, 1)

philipmannering

Question 2)

I may have misunderstood, but you can use a Select Tool to remove fields that you do not need.

Or, alternatively, the configuration of the Append Fields Tool will let you deselect fields.

aparna0208

@PhilipMannering Thanks for the input. This doesn't seem to work. I tried this formula but there is no comma in the output.

aparna0208

I tried it already by selecting/deselecting the column I want in the output file and the problem is it works but it gets appended to the bottom of the existing output and not to the right

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703