Remove Initial Structure
When you import a dataset from a file, the Alteryx Analytics Cloud attempts to detect the structure of the file and to apply an initial set of parsing steps to the data to render it in tabular form for display in the Transformer page. For example, JSON files may be turned into a table of data as long as the structure of the data supports this structuring.
Note
Initial parsing steps are applied only to file-based sources of data.
These steps vary based on the file format of data that is being imported. Depending on the dataset, you may need to modify these steps or rebuild them altogether. You can use the following steps to prevent the Alteryx Analytics Cloud from detecting the structure and automatically hiding these steps.
Tip
You should allow the product to detect the structure first. If it does not detect the structure well, you can experiment with disabling it and rebuilding the steps to render your data in tabular format.
Tip
If you have already imported the dataset and need to change this setting, you can re-import the source and change the settings. Wherever the previously imported version of this dataset is referenced, you must change the reference to use this newly imported dataset.
Import Unstructured Dataset
After you have selected or specified the file to import in the Import Data page, click Edit Settings for the dataset card in the right panel.
Deselect the Detect Structure checkbox. For more information, see File Import Settings.
Continue the import process by adding the dataset.
When the imported dataset is added, it is listed as an unstructured dataset.