Export an Analyze data table to PlaidCloud Document as a JSON file. There are several options (shown below) for data orientation.
For more details on JSON files, see the JSON official website here: http://json.org/.
JSON files do not retain column order. The column order in the source data table does not necessarily reflect the column order in the exported file.
See details here: Source and Target
Consider the following data set:
JSON files can be exported into one of four data formats:
Specify Date Format using the dropdown menu. Choose from the following formats:
Specify Date Unit using the dropdown menu. Choose from the following formats, listed in order of increasing precision:
Select this checkbox to ensure that all strings are encoded in proper ASCII format. This is enabled by default.
All exported files are uncompressed, but the following compression options are available:
Remember that JSON files do not retain column order. Adjustments to column order during this step may not be accurately reflected in the exported JSON file.
See details here: Table Data Selection
To allow for maximum flexibility, data filters are available on the source data and the target data. For larger data sets, it can be especially beneficial to filter out rows on the source so the remaining operations are performed on a smaller data set.
Any valid Python expression is acceptable to subset the data. Please see Expressions for more details and examples.
Compound filters must have individual elements wrapped in parentheses. For example, if filtering for Temperature and Humidity, a valid filter would look like this:
To report duplicates, select the Report Duplicates in Table checkbox and then specify an output table which will contain all of the duplicate records.
This will not remove the duplicate items from the target data table. To remove duplicate items, use the Distinct menu options as specified in the [Table Data Selection](../transforms/common_features#table-data-selection) section.
Example code here
See details here: Source Table Slicing
See details here: Select Subset of Final Data
See details here: Final Data Table Slicing
In this example, the Analyze Source Table Import Google Spreadsheet is exported to the json file Export JSON Records orientation in the Analyze Demo Output directory of PlaidCloud Document.
Next, all columns are mapped in the Table Data Selection. No additional operations are performed. Remember that column order is not necessarily retained in the output json file.