How to split columns in a data set?

[bkaplan23]

I uploaded a data set into Foundry that has 4 columns, but for some reason when I uploaded it to foundry it combines everything into 1 column. What is the quickest way to split this into 4 columns?

[bkaplan]

From the data preview, you can manually edit schema. There is an option to automatically infer the schema or to set it.

[bkaplan23]

Part of the issue I am having is that the delimiter isn’t so clear

[bkaplan]

What do you mean by the delimiter is not clear? How would you know how to split it into the 4 columns then?

[arukavina]

Hi @bkaplan23, can you show us a preview of the file (hiding all confidential values)

Is it delimiter separated or fixed width?

[bkaplan23]

Here is an example of what it looks like. For some reason all in one column and all rows split into 2:
embedded description, code, property, category
“[ 0.010 -0.00871 -0.00309 … -0.026672 -0.0109
-0.010]”,A1,“Property property”,House

[arukavina]

I’ve recreated your file:

1. Uploaded it into foundry.
2. Applied the default schema.
   
   
3. Then edited it selecting Quotes: Double , and Columns: Comma

and it works fine.

Note: Make sure you’re using normal " (double quotes)