Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next


Output: Reshapes your dataset to include ProdId  column and new columns for each distinct value in the Dates column. Each distinct ProdId value is represented by a separate row in the reshaped dataset. Within each row, the new columns contain a sum of sales for the product for each date in the dataset.    

D s

D code

pivot col:column_ref value: FUNCTION(arg1,arg2) [group: group_col] [limit:int_num]