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 |
Solved! Go to Solution.
Question 1)
Best way is to use a formula tool with the formula,
ToString([Field1], 0, 1)
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.
@PhilipMannering Thanks for the input. This doesn't seem to work. I tried this formula but there is no comma in the output.
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
Could you share the workflow you have so far? Preferably with Text Inputs.
@PhilipMannering I have attached the workflow
@PhilipMannering It worked. Thanks a lot for all your help on this:)