Output

[aparna0208]

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

[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

[PhilipMannering]

Could you share the workflow you have so far? Preferably with Text Inputs.

[aparna0208]

@PhilipMannering I have attached the workflow

[PhilipMannering · Accepted solution]

Does this help?

[aparna0208]

@PhilipMannering It worked. Thanks a lot for all your help on this:)