TC.vtcRotateMultipleCells

Retrieves the first field from the specified columns and moves the values to the bottom. If the column name does not exist, a null value is returned and a new column is added to the table.

Equivalent method in VuGen: lrvtc_rotate_messages1

Arguments

Name Description
colNames(string) The names of the columns, delimited by a semicolon.
option

  • (integer) Defines how the values are rotated.

    • 0. Same row. Retrieve data from all columns and move it to the bottom for all columns, based on the column with the highest row count. The created row is n+1 for all columns.

    • 1. Add as stack. Retrieve data from all columns and move it to the bottom to the last valid row of every column.

    • 2. Add as unique stack. Retrieve data from all columns and move it to the bottom to the last valid row of every column only if the data is unique.

    vtsName

    (Optional)

    		(string) The alias of the VTS server.

    Return value

    A promise fulfilled with an object, which contains the first field from the specified columns. If a column is empty or does not exist, the value is null. For example, {col1:"larry",col2:""}

    Example

    Copy code
    (async ()=>{
        let datas = await TC.vtcRotateMultipleCells("MyColumn1;MyColumn2", 1);
    })();