Excel: Save spreadsheet to data table - Options to determine column types

Ian_210989
Ian_210989 Posts: 42 admin
edited February 2020 in Ideas

Provide an options for the action, Excel: Save spreadsheet to data table, to determine column types:
1. Infer column types based on data (default)
2. Manually define column types
3. Set all column types to text

7
7 votes

Swept · Last Updated

Comments

  • Devon_161545
    Devon_161545 Posts: 16
    edited February 2020

    I disagree with automatically inferring. I would prefer a method to be able to define it in a table load. Such as Row 1 = headers, row 2 (optional) = field type. I'm having to reset many of my columns because the limited data set in testing keeps selecting "Choice" instead of text. And it changes my "Yes/No" choice column into a "True/False" column.

  • Jeff_146001
    Jeff_146001 Posts: 296 admin

    @Devon_161545 I agree with your feedback. I've gone ahead and update the title and description of this idea to provide 3 different options for determining column types.

  • @Devon_161545 - in your data table columns, how are you getting the 'Choice' field type? I'm purposely trying to set this field as choice but it keeps changing to long text...