Data Prep
      Back to home
      1. Help Center
      2. Data Prep

      Shift Values

      Shifts selected Value columns by number of rows

      Function:

      Shift_Values(table = string, cols = list, n_rows = integer)

       

      Parameters:

      Table: Table name on which to perform function

      Columns to Shift: Columns to shift

      Number of Rows to Shift: Number of rows to shift

       

      Examples:

      Shift_Values(table = Budget, cols = ["Plan", "Actuals"], n_rows = 3)