Editable, Boolean or Multistate fields types cannot be changed, however the data within these fields in the database can be changed. If the original field type is a Virtual field, it can only be changed to another Virtual type, for example Virtual Character to Virtual Date. In the drop-down list, select the required field type.A drop-down list appears in the type description. In the Type column, click the type description for the required field.The Field Manipulation dialog box appears. For example instead of changing the type of a field from Character to Numeric, create a new Virtual Numeric field using On the Data tab, in the Fields group, click the Field Manipulation dialog box launcher (the arrow in the bottom right corner of the Fields group). To avoid this, instead of changing a field’s definition, append a new field to the database with the required definition. Results may be made valid again by returning the settings to what they were when the result was created. Making changes to the database through Field Manipulation may cause any output based on that field such as results, drill downs, indices and views to appear incorrect or invalid. To take advantage of the Editable Time feature, you must convert your pre-IDEA Version Nine databases to the current database format.If you change a Date or Time field and the mask does not match the data, the data is treated as bad data and displayed as “Error”.If you change a Character field that contains numbers with leading zeroes to Numeric, IDEA removes the leading zeroes.If you change a Character field that contains at least one alphabetical character to Numeric, the records in that field will default to 0.If necessary, change the field types in order to match fields. IDEA can only match fields with the same field type when performing the Join Databases, Append Databases, and Compare Databases tasks. What about date fields? If something doesn’t come in as a proper date, can the field type be changed to date and be proper?Ī: Fields can be changed to a Date/Time field and you can specify the date mask. Q: You show the ability to change field types from numbers to characters.
These are the answers to the last question from attendees. In part 1 of this series, we answered some of the questions we received from our audience about some of 10.3’s features and enhancements, such as Python integration. We recently hosted a webinar to launch version 10.3 of CaseWare IDEA Data Analysis software.
0 kommentar(er)
