Hi,

I'm getting input from a user via a dropdown, they can select employees or managers, which will run 2 separate SQL queries depending on which option was chosen and return the results as JSON data. The 2 datasets have many of the same columns, with only a handful unique to each, so in my javascript I've specified 2 variables to hold the "common" and "unique" columns and have then spread them in the columns property.

However, the columns appear in the datatable as per the order of the columns array, so my unique columns are appearing at the end currently, which is not what I want.

Is there a way within the column object itself to define its position in the table? E.g.

{
        data: "id",
        title: "Employee ID",
        visible: true,
        position: 0
}

Kind regards,
Guy

const commonColumns = [         
    { 
        data: "firstName",
        title: "First Name",
        visible: true
    },
    { 
        data: "lastName",
        title: "Last Name",
        visible: true
    },
    { 
        data: "age",
        title: "Age",
        visible: true
    }
    etc...
];


const uniqueColumns = {
    'EMP' : [
        {
            data: "id",
            title: "Employee ID",
            visible: true
        },
        {
            data: "manager",
            title: "Manager",
            visible: true
        }
    ],
    'MAN' : [
        {
            data: "teamName",
            title: "Team Name",
            visible: true
        },
        {
            data: "budget",
            title: "Budget",
            visible: true
        }
        etc...
    ]
}


...
columns: [
    ...commonColumns,
    ...uniqueColumns[cohortSelected]
],
...