I have a file with a link ID. It is a concatenated field compiled of three fields. One of the fields has leading zeros and I need my LinkID field to show the leading zeros. e.g. In the account field I have 0010, what appears in my link ID field is 10. How can I get it to show 0010 in the Link ID. File attached.
Thanks as always :-)