In the first run, it will always create a new file and write the data to that destination. In any subsequent runs, the user can choose how to write the file.
If the Append to File (If Exists) option is checked, the file will be appended to the existing Excel file. If the option is left unchecked, the Excel file will be overwritten.
If the Write to Multiple Files option is checked, the data will be written at the dynamic file path provided by the user.
For more information, check out this video on writing data to multiple files using a single destination object in Astera.
We cannot export the Object Path column to any destination. It only tells you the path from which the record is coming. If your output is in a hierarchical format, it will show the course of the entire hierarchy. For example, in the screenshot below, the data field ‘Title’ comes from the ‘EmployeesToBePaid’ object.
Tools Menu > Data Format has different date formats, but it doesn’t seem to do anything. Each time I go into it, it still has the first option selected even after choosing a different one.
This is because you can only add a new date format in Tools > Data Formats, but you cannot change any data field’s date format. However, if you want to change the date format, you can do it while exporting your data by specifying the format you wish to apply to your date field.
I want to change the output format of a column, say integer to string, or vice versa. Any error trapping abilities with that conversion?
Yes, in Astera, you can change the data types of fields while exporting the data. Although you can convert the integer data type to string data type, vice versa is only possible if your string data type is convertible to an integer data type. Else, Astera will give an error and create a record level log of those erroneous records.
Yes, in a Delimited File Destination object, you can either choose a Field Delimiter from the drop-down list or specify one according to your dataset.
Also, while exporting to a Delimited File Destination, you have the flexibility to choose whether you want to export it in .CSV format or .txt format.
