Data Manipulation

Discussion List

• 
  Is there a way to change column type?

  Answered Billford_181500 30 views 2 comments 0 points Most recent by Kevin_129457 June 9Questions
• 
  Is there any way to set column as autofit in Excel

  Answered William_897866 23 views 1 comment 0 points Most recent by William_897866 April 29Questions
• 
  Updating all available rows in a Table with a default value

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

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

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

  Thomas_937381 6 views 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 14 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 14 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 13 views 1 comment 0 points Most recent by Thomas_937381 July 2020Show and Tell
• 
  Imported Table Remove All Rows

  Answered Meghan_550057 99 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 4 views 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 2 views 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 4 views 0 comments 0 points Started by Thomas_937381 July 2020 Show and Tell
• 
  Pattern: Reorder, Rename, and Fill Columns in a Dataset

  Thomas_937381 21 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 6 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 23 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 32 views 1 comment 1 point Most recent by Thomas_937381 June 2020Questions
• 
  Summarize CSV: Sum Values by Unique Identifier

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

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

  Accepted Answer Jozef_783863 33 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 4 views 1 comment 0 points Most recent by Jeff_146001 January 2020Ideas
• 
  How to Reference Data Table Row IDs

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

  Arjun_839690 32 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 16 views 0 comments 5 points Started by Anna_272419 November 2019 Ideas
• 
  7

  Up
  Excel: Transpose range - new action

  Open Ian_210989 14 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 14 views 0 comments 7 points Started by Meghan_550057 November 2019 Ideas