Data Manipulation

Discussion List

• 
  Updating all available rows in a Table with a default value

  Accepted Answer Kelsey_827704 11 views 2 comments 0 points Most recent by Kelsey_827704 March 5Questions
• 
  Concatenation of Two Fields for Spreadsheet and/or Table

  Answered Stephen_146116 31 views 3 comments 0 points Most recent by Stephen_146116 January 26Questions
• 
  How to Pivot Data with Catalytic (Using MapReduce!)

  Sean_510793 63 views 5 comments 2 points Most recent by William_134612 December 2020Show and Tell
• 
  Pattern: Contains Operator for Data Table Filter

  Thomas_937381 1 view 2 comments 1 point Most recent by Jozef_783863 September 2020Show and Tell
• 
  Data Validation with more complicated math

  Answered Cora_507115 71 views 13 comments 1 point Most recent by Jozef_783863 August 2020Questions
• 
  Pattern: Consolidate Table Rows from Individual Surveys

  Thomas_937381 11 views 0 comments 0 points Started by Thomas_937381 July 2020 Show and Tell
• 
  Pattern: Convert Table in PDF Document to Data Table

  Thomas_937381 11 views 0 comments 0 points Started by Thomas_937381 July 2020 Show and Tell
• 
  Pattern: Join Datasets via Similar Text

  Thomas_937381 2 views 0 comments 0 points Started by Thomas_937381 July 2020 Show and Tell
• 
  Pattern: Convert HTML Table to Catalytic Data Table

  Thomas_937381 11 views 1 comment 0 points Most recent by Thomas_937381 July 2020Show and Tell
• 
  Imported Table Remove All Rows

  Answered Meghan_550057 91 views 6 comments 1 point Most recent by Jozef_783863 July 2020Questions
• 
  Pattern: Extract Fixed Number of Values Adjacent to Labels in .PDF Document

  Thomas_937381 1 view 0 comments 0 points Started by Thomas_937381 July 2020 Show and Tell
• 
  Pattern: On First Calendar Day of Month, Filter Table for All Entries from Last Month

  Thomas_937381 1 view 0 comments 0 points Started by Thomas_937381 July 2020 Show and Tell
• 
  Pattern: Filter Random Sample of Data Table Rows, Variably up to 50 Rows

  Thomas_937381 1 view 0 comments 0 points Started by Thomas_937381 July 2020 Show and Tell
• 
  Pattern: Reorder, Rename, and Fill Columns in a Dataset

  Thomas_937381 13 views 0 comments 1 point Started by Thomas_937381 July 2020 Show and Tell
• 
  Pattern: Delimit .TXT or .CSV File with New Delimiter

  Thomas_937381 2 views 0 comments 1 point Started by Thomas_937381 July 2020 Show and Tell
• 
  Pattern: Split Dataset by Variable Maximum Number of Rows

  Thomas_937381 22 views 0 comments 1 point Started by Thomas_937381 July 2020 Show and Tell
• 
  Formula: Leading Zeros in CSV Files

  Thomas_937381 12 views 0 comments 1 point Started by Thomas_937381 July 2020 Show and Tell
• 
  Leading Zeros in a CSV With Column Header Not in First Row

  Accepted Answer Thomas_937381 31 views 1 comment 1 point Most recent by Thomas_937381 June 2020Questions
• 
  Summarize CSV: Sum Values by Unique Identifier

  Accepted Answer Thomas_937381 51 views 4 comments 2 points Most recent by Dylan_478989 June 2020Questions
• 
  Currency Converter

  Nicholas_187159 21 views 0 comments 1 point Started by Nicholas_187159 June 2020 Show and Tell
• 
  Split Table Every 500 Rows

  Accepted Answer Jozef_783863 31 views 4 comments 0 points Most recent by Roberto_142863 April 2020Questions
• 
  1

  Up
  Tables: Column Permission Setting

  Open Jacob_154284 11 views 0 comments 1 point Started by Jacob_154284 March 2020 Ideas
• 
  0

  Up
  Create a Data Table with pre-set column validation

  Open Jacob_154284 2 views 1 comment 0 points Most recent by Jeff_146001 January 2020Ideas
• 
  How to Reference Data Table Row IDs

  Accepted Answer Jozef_783863 61 views 2 comments 0 points Most recent by Jozef_783863 January 2020Questions
• 
  Deleting blanks rows from a table

  Arjun_839690 31 views 1 comment 1 point Most recent by Jozef_783863 December 2019Questions
• 
  5

  Up
  New Action - Excel: Remove blank rows and columns

  Open Anna_272419 11 views 0 comments 5 points Started by Anna_272419 November 2019 Ideas
• 
  7

  Up
  Excel: Transpose range - new action

  Open Ian_210989 11 views 0 comments 7 points Started by Ian_210989 November 2019 Ideas
• 
  7

  Up
  Excel: Add, Remove and Reorder Multiple Columns: Single Action

  Open Meghan_550057 11 views 0 comments 7 points Started by Meghan_550057 November 2019 Ideas
• 
  1

  Up
  CSV: Change Delimiter action

  Open Product_Request 1 view 0 comments 1 point Started by Product_Request October 2019 Ideas
• 
  2

  Up
  Tables: Add, Remove and Reorder multiple columns

  Open Product_Request 1 view 0 comments 2 points Started by Product_Request October 2019 Ideas