{"version":1,"pages":[{"id":"MAoUasxkKW3tKtWrEb0k","title":"Introduction to Tomat","pathname":"/","siteSpaceId":"sitesp_4w7pJ","emoji":"1f44b","description":"Open, analyze and automate Excel and CSV without code."},{"id":"lLogu8LUER3vBeHlLVwM","title":"Product Updates","pathname":"/getting-started/product-updates","siteSpaceId":"sitesp_4w7pJ","description":"Welcome! You can find the latest product updates listed down below by their release dates.","breadcrumbs":[{"label":"Getting Started"}]},{"id":"eGHfyIhbAmxqVkhnkpBg","title":"Beginner's Guide","pathname":"/getting-started/beginners-guide","siteSpaceId":"sitesp_4w7pJ","description":"A Beginner's Guide to Data Analysis in Tomat: Connecting Data and Exploring Insights","breadcrumbs":[{"label":"Getting Started"}]},{"id":"aKyfgJv7kqym7vT7acD8","title":"FAQ","pathname":"/getting-started/faq","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Getting Started"}]},{"id":"dhxnZP2mATUQ3TL31Jrx","title":"Home Page","pathname":"/product-overview/home-page","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Product overview"}]},{"id":"0cU5od3vh8ngrMltWpNG","title":"Exploring Data","pathname":"/product-overview/exploring-data","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Product overview"}]},{"id":"DCbuhnHfHpCerMX2ETL9","title":"Data Catalog","pathname":"/product-overview/exploring-data/data-catalog","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Product overview"},{"label":"Exploring Data"}]},{"id":"nWQGhHt8urXpIYoGG4iv","title":"Exploring Datasets","pathname":"/product-overview/exploring-data/exploring-datasets","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Product overview"},{"label":"Exploring Data"}]},{"id":"uhDmBLATE0O6ovyQwrnK","title":"Statistics Panel","pathname":"/product-overview/exploring-data/statistics-panel","siteSpaceId":"sitesp_4w7pJ","description":"Exploratory Data Analysis","breadcrumbs":[{"label":"Product overview"},{"label":"Exploring Data"}]},{"id":"okvcei2829F1fzLqTEMh","title":"Designing Flows","pathname":"/product-overview/designing-flows","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Product overview"}]},{"id":"AHDgD7FysoduMEHeEsUA","title":"Creating Flows","pathname":"/product-overview/designing-flows/creating-flows","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Product overview"},{"label":"Designing Flows"}]},{"id":"TWyN5WTp3YZxwsJl85Oq","title":"Flow Designer Guide","pathname":"/product-overview/designing-flows/flow-designer-guide","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Product overview"},{"label":"Designing Flows"}]},{"id":"Ys9EiUX20lVdW8YbLPs7","title":"Working with Canvas","pathname":"/product-overview/designing-flows/flow-designer-guide/working-with-canvas","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Product overview"},{"label":"Designing Flows"},{"label":"Flow Designer Guide"}]},{"id":"MhxVmfsRqsOIxNNuy8Gc","title":"Using Groups","pathname":"/product-overview/designing-flows/flow-designer-guide/using-groups","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Product overview"},{"label":"Designing Flows"},{"label":"Flow Designer Guide"}]},{"id":"4mdxyYzApGzgxK1SBGMw","title":"Working with Table","pathname":"/product-overview/designing-flows/flow-designer-guide/working-with-table","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Product overview"},{"label":"Designing Flows"},{"label":"Flow Designer Guide"}]},{"id":"EZqaJS6EqiegPG01I4gY","title":"Managing Flows","pathname":"/product-overview/designing-flows/managing-flows","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Product overview"},{"label":"Designing Flows"}]},{"id":"2io8WRlJUzt2OA4W0Maj","title":"Demo: Building a Simple Flow","pathname":"/product-overview/designing-flows/demo-building-a-simple-flow","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Product overview"},{"label":"Designing Flows"}]},{"id":"UyAMyrVjcT4vpevOHN9R","title":"Executing Flows","pathname":"/product-overview/executing-flows","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Product overview"}]},{"id":"m9chRX1bwK5Z0ZSdRQJ4","title":"Running Flows","pathname":"/product-overview/executing-flows/running-flows","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Product overview"},{"label":"Executing Flows"}]},{"id":"NvyN0zovXzONkbQIYLiD","title":"Jobs overview","pathname":"/product-overview/executing-flows/jobs-overview","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Product overview"},{"label":"Executing Flows"}]},{"id":"GA4CMZq69rolBipMpeCi","title":"Building Reports","pathname":"/product-overview/building-reports","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Product overview"}]},{"id":"gU6kKhzSfJ2qS5Zdfpmc","title":"Designing Reports","pathname":"/product-overview/building-reports/designing-reports","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Product overview"},{"label":"Building Reports"}]},{"id":"Ubt3PJF4VAu1vez0ISK3","title":"Running Reports","pathname":"/product-overview/building-reports/running-reports","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Product overview"},{"label":"Building Reports"}]},{"id":"TGN6xfuPobV15cmEkUnu","title":"Reports Page","pathname":"/product-overview/building-reports/reports-page","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Product overview"},{"label":"Building Reports"}]},{"id":"kOFzIh1srLZ7pRptkJ2Z","title":"Tomat Use Cases","pathname":"/product-overview/tomat-use-cases","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Product overview"}]},{"id":"coXGxWeTjYN0ZnaPfxOn","title":"Transforms","pathname":"/data-transformation/transforms","siteSpaceId":"sitesp_4w7pJ","description":"The concept of a node is central to the data transformation process. Each node represents a specific data transformation action with its associated settings. Nodes are the building blocks of the data","breadcrumbs":[{"label":"Data Transformation"}]},{"id":"U7j2C8H8H6PTlxnKgiSy","title":"Source","pathname":"/data-transformation/transforms/source","siteSpaceId":"sitesp_4w7pJ","description":"Adds datasets to the flow","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"mLOtLMY5Lv6CHpkqFqXs","title":"New Empty Table","pathname":"/data-transformation/transforms/new-empty-table","siteSpaceId":"sitesp_4w7pJ","description":"Adds empty table to the flow, you can manually add and edit data.","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"0Hgl21Io7LQyZ9KOzfrD","title":"Output","pathname":"/data-transformation/transforms/output","siteSpaceId":"sitesp_4w7pJ","description":"Saves the result of data flow in an outer dataset.","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"T3fllRuwGmXMkjUDTbPz","title":"Chart","pathname":"/data-transformation/transforms/chart","siteSpaceId":"sitesp_4w7pJ","description":"Create a chart.","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"qgCmJVrLNCWykOEj76R6","title":"New Column","pathname":"/data-transformation/transforms/new-column","siteSpaceId":"sitesp_4w7pJ","description":"Adds a new column with “text”, number, or function","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"lvf3SXBkAU0yQY65XdmZ","title":"If...Then","pathname":"/data-transformation/transforms/if...then","siteSpaceId":"sitesp_4w7pJ","description":"Adds a new column with a value based on the specified condition","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"3SoAz0W8ZxvXgh3sgdQ4","title":"Rolling Functions","pathname":"/data-transformation/transforms/rolling-functions","siteSpaceId":"sitesp_4w7pJ","description":"Calculates a window function operates on a group (“window”) of related rows","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"GnqELalwD6jLe9AxYfdi","title":"Column Type","pathname":"/data-transformation/transforms/column-type","siteSpaceId":"sitesp_4w7pJ","description":"Changes a data type for selected column(s)","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"Fnw1rECiTiGejppWJ7Co","title":"Columns Edit","pathname":"/data-transformation/transforms/columns-edit","siteSpaceId":"sitesp_4w7pJ","description":"Renames, deletes and moves columns","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"HKeNqCrNWfZF4cFXBRSN","title":"Sort","pathname":"/data-transformation/transforms/sort","siteSpaceId":"sitesp_4w7pJ","description":"Sorts a table by the specified column(s)","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"N6lqlo52oMZxxgFiMVCc","title":"Filter","pathname":"/data-transformation/transforms/filter","siteSpaceId":"sitesp_4w7pJ","description":"Filters rows based on the specified condition","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"8uaLucUyJz4g4wlWLHY0","title":"Remove Duplicates","pathname":"/data-transformation/transforms/remove-duplicates","siteSpaceId":"sitesp_4w7pJ","description":"Removes duplicated rows","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"ERUhieEis5D0DdZJmK3x","title":"Split Text","pathname":"/data-transformation/transforms/split-text","siteSpaceId":"sitesp_4w7pJ","description":"Adds a new column with a value based on the specified condition","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"tjowAC0eeRxOckn9OjPS","title":"Extract Text","pathname":"/data-transformation/transforms/extract-text","siteSpaceId":"sitesp_4w7pJ","description":"Extracts the specified part of text into a new column(s)","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"JZc9XQCutE2p27AK2R2u","title":"Find and Replace Text","pathname":"/data-transformation/transforms/find-and-replace-text","siteSpaceId":"sitesp_4w7pJ","description":"Finds and replaces the specified part of text","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"ZtlEWuMoepZryK9sjWeU","title":"Match Text","pathname":"/data-transformation/transforms/match-text","siteSpaceId":"sitesp_4w7pJ","description":"Adds a new column with a value based on the specified condition","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"I1pCeM12aDqupuck3DSv","title":"Join","pathname":"/data-transformation/transforms/join","siteSpaceId":"sitesp_4w7pJ","description":"Joins 2 tables using the specified columns as keys","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"IUQQv3hzMjo5GtZ021iU","title":"Union","pathname":"/data-transformation/transforms/union","siteSpaceId":"sitesp_4w7pJ","description":"Stacks rows of two or more tables","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"xilWRhWIU0jht5r8iMpa","title":"Group By","pathname":"/data-transformation/transforms/group-by","siteSpaceId":"sitesp_4w7pJ","description":"Groups rows and calculate aggregation functions","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"L7KQq6pYmDAezpnQRGYA","title":"Pivot","pathname":"/data-transformation/transforms/pivot","siteSpaceId":"sitesp_4w7pJ","description":"Creates new columns from values in the specified columns and computes aggregation functions as values for the new columns","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"oI3KMyIahB4iTUGNW4CM","title":"Unpivot","pathname":"/data-transformation/transforms/unpivot","siteSpaceId":"sitesp_4w7pJ","description":"Reshapes the data by merging one or more columns into key and value columns","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"WdcUcPtnDPdhdXKiCOtM","title":"To JSON","pathname":"/data-transformation/transforms/to-json","siteSpaceId":"sitesp_4w7pJ","description":"Creates Objects or Arrays in JSON format from the specified columns","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"Shugd9s1AJ8E3flHAqSI","title":"From JSON","pathname":"/data-transformation/transforms/from-json","siteSpaceId":"sitesp_4w7pJ","description":"Flatten JSON to columns and rows","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"cb928qvomzJW1wWU8ZXg","title":"API Call","pathname":"/data-transformation/transforms/api-call","siteSpaceId":"sitesp_4w7pJ","description":"Calls an external API and return a new column with answers","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"WgnHh23mscj6YZGTuE3K","title":"Use AI","pathname":"/data-transformation/transforms/use-ai","siteSpaceId":"sitesp_4w7pJ","description":"Calls AI for each row to extract, enrich or cleanup.","breadcrumbs":[{"label":"Data Transformation"},{"label":"Transforms"}]},{"id":"BKcaB4hagMzMQnXFAopC","title":"Formulas","pathname":"/data-transformation/formulas","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"}]},{"id":"hsIVVgxQp0QmBH4M9nPY","title":"What are Formulas?","pathname":"/data-transformation/formulas/what-are-formulas","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"}]},{"id":"eC7pwvv8N24sKAtFUMbN","title":"Math Functions","pathname":"/data-transformation/formulas/math-functions","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"}]},{"id":"lhDkWpxBplFn0BDEsse3","title":"Abs","pathname":"/data-transformation/formulas/math-functions/abs","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Math Functions"}]},{"id":"V84RhQU9vlFhH5vGbhom","title":"Ceiling","pathname":"/data-transformation/formulas/math-functions/ceiling","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Math Functions"}]},{"id":"6puONVkItXXnFWlhlIVe","title":"Exp","pathname":"/data-transformation/formulas/math-functions/exp","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Math Functions"}]},{"id":"oWgwsgDcbMCJMSLGO5EP","title":"Floor","pathname":"/data-transformation/formulas/math-functions/floor","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Math Functions"}]},{"id":"nCBLN0aVQEOVy6fs1FQk","title":"IsEven","pathname":"/data-transformation/formulas/math-functions/iseven","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Math Functions"}]},{"id":"FCsHH7ECd738BOTy1IYu","title":"IsOdd","pathname":"/data-transformation/formulas/math-functions/isodd","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Math Functions"}]},{"id":"f1BnUtKPzba9IoCvlpg7","title":"Ln","pathname":"/data-transformation/formulas/math-functions/ln","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Math Functions"}]},{"id":"y9tH4piNmRADYmZi18MY","title":"Log","pathname":"/data-transformation/formulas/math-functions/log","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Math Functions"}]},{"id":"963zLquwTTUGMSIq7s5d","title":"Log10","pathname":"/data-transformation/formulas/math-functions/log10","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Math Functions"}]},{"id":"gMi3gAjThTPFQ8sAvsev","title":"Mod","pathname":"/data-transformation/formulas/math-functions/mod","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Math Functions"}]},{"id":"bf6HWgCRQ6j1tbyezQK8","title":"Pi","pathname":"/data-transformation/formulas/math-functions/pi","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Math Functions"}]},{"id":"NqywWpratZ88TNyAS7L4","title":"Power","pathname":"/data-transformation/formulas/math-functions/power","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Math Functions"}]},{"id":"xEBNXZh7WjfpQuNDMHVz","title":"Quotient","pathname":"/data-transformation/formulas/math-functions/quotient","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Math Functions"}]},{"id":"BV5tdR1wnSWVydlgWo1B","title":"Round","pathname":"/data-transformation/formulas/math-functions/round","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Math Functions"}]},{"id":"NjMB7lHfDT7ZKGZe3MTY","title":"RoundDown","pathname":"/data-transformation/formulas/math-functions/rounddown","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Math Functions"}]},{"id":"ZhS7kW95M0VnjYh5k9FK","title":"RoundUp","pathname":"/data-transformation/formulas/math-functions/roundup","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Math Functions"}]},{"id":"blaEqQAi7bkoKliXYL0E","title":"Sign","pathname":"/data-transformation/formulas/math-functions/sign","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Math Functions"}]},{"id":"iMyJZ5DM0flcWOf7GzOG","title":"Sqrt","pathname":"/data-transformation/formulas/math-functions/sqrt","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Math Functions"}]},{"id":"xRRsrSBZ9JEPtceL3F8Y","title":"Truncate","pathname":"/data-transformation/formulas/math-functions/truncate","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Math Functions"}]},{"id":"0hO5HygQaXMIuuBs5bdM","title":"Trigonometric Functions","pathname":"/data-transformation/formulas/trigonometric-functions","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"}]},{"id":"4fdYPBSTjyqJczz9ZMLD","title":"Acos","pathname":"/data-transformation/formulas/trigonometric-functions/acos","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Trigonometric Functions"}]},{"id":"to7OC8HRwGhorw6Hn0ci","title":"Asin","pathname":"/data-transformation/formulas/trigonometric-functions/asin","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Trigonometric Functions"}]},{"id":"bXAr1lZRT15FSwcjP0Qo","title":"Atan","pathname":"/data-transformation/formulas/trigonometric-functions/atan","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Trigonometric Functions"}]},{"id":"80bMxLLJjzj9pAnGUM00","title":"Atan2","pathname":"/data-transformation/formulas/trigonometric-functions/atan2","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Trigonometric Functions"}]},{"id":"tOEFdqs3ZragbOk7cU5f","title":"Cos","pathname":"/data-transformation/formulas/trigonometric-functions/cos","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Trigonometric Functions"}]},{"id":"DX5SbizY9S3UK5wAU11b","title":"Cot","pathname":"/data-transformation/formulas/trigonometric-functions/cot","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Trigonometric Functions"}]},{"id":"yIMWlYEuVd7i0DMJYpOj","title":"Degrees","pathname":"/data-transformation/formulas/trigonometric-functions/degrees","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Trigonometric Functions"}]},{"id":"tKtUfHX3J2r2qMdy7cR3","title":"Radians","pathname":"/data-transformation/formulas/trigonometric-functions/radians","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Trigonometric Functions"}]},{"id":"1bnwIo4MzMCVLbkNJXqj","title":"Sin","pathname":"/data-transformation/formulas/trigonometric-functions/sin","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Trigonometric Functions"}]},{"id":"YL7rjfLPUlUdokLDDy2P","title":"Tan","pathname":"/data-transformation/formulas/trigonometric-functions/tan","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Trigonometric Functions"}]},{"id":"o1nHE7Pc34yNaU0qbmej","title":"String Functions","pathname":"/data-transformation/formulas/string-functions","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"}]},{"id":"HsmhzDHbciuL5Hn240Vf","title":"Compare","pathname":"/data-transformation/formulas/string-functions/compare","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"jbiH7JTFmwALmAtAs6rO","title":"Concat","pathname":"/data-transformation/formulas/string-functions/concat","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"2fFSMMqJD8DB6ocyPAGK","title":"Contains","pathname":"/data-transformation/formulas/string-functions/contains","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"xG6v1btVcnCpACFY8bfO","title":"In","pathname":"/data-transformation/formulas/string-functions/in","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"46NRit7apuqBBW1mIryl","title":"CountMatches","pathname":"/data-transformation/formulas/string-functions/countmatches","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"1VOD06FWwJUVC8SWkjSu","title":"CountMatchesRegexp","pathname":"/data-transformation/formulas/string-functions/countmatchesregexp","siteSpaceId":"sitesp_4w7pJ","description":"Regexp","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"aihfGLII0SBrWZXltH7N","title":"EndsWith","pathname":"/data-transformation/formulas/string-functions/endswith","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"8ie81FrHMX8wGWtHUPFn","title":"EndsWithRegexp","pathname":"/data-transformation/formulas/string-functions/endswithregexp","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"tgiZFl5rHiG5uggiIfCg","title":"Extract","pathname":"/data-transformation/formulas/string-functions/extract","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"5FpTU7mn3Q8Qz1VhobqI","title":"FindMatchOfString","pathname":"/data-transformation/formulas/string-functions/findmatchofstring","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"tMNZV0eieHn88pBYbbdo","title":"FindMatchOfRegexp","pathname":"/data-transformation/formulas/string-functions/findmatchofregexp","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"ivf8Jbx2X6MuQN3WduIW","title":"FindMatchesOfString","pathname":"/data-transformation/formulas/string-functions/findmatchesofstring","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"rk18vJkdA0fCtb5LCBwj","title":"FindMatchesOfRegexp","pathname":"/data-transformation/formulas/string-functions/findmatchesofregexp","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"oFAAn3UasmwUryHWJNvl","title":"Left","pathname":"/data-transformation/formulas/string-functions/left","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"2pho2zjftVM97DsQxI5w","title":"Length","pathname":"/data-transformation/formulas/string-functions/length","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"vU09HaRHtTtzECpdxhHw","title":"Lower","pathname":"/data-transformation/formulas/string-functions/lower","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"L6b6QlRcm1OfaWC5TiPc","title":"Matches","pathname":"/data-transformation/formulas/string-functions/matches","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"jfIByyxjVUxOVjYMLwNT","title":"Pad","pathname":"/data-transformation/formulas/string-functions/pad","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"qUDj9OLO5i5qpw8fILyR","title":"ProperCase","pathname":"/data-transformation/formulas/string-functions/propercase","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"tqrsklOKiH6z6Vw3BK0b","title":"RemoveSymbols","pathname":"/data-transformation/formulas/string-functions/removesymbols","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"MchUgnBGmqTvLYuwtz6G","title":"RemoveWhitespaces","pathname":"/data-transformation/formulas/string-functions/removewhitespaces","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"uUeaHzQWouSzYQZvdYPj","title":"Repeat","pathname":"/data-transformation/formulas/string-functions/repeat","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"hKq0kp2tEW0b1OpBSFax","title":"Replace","pathname":"/data-transformation/formulas/string-functions/replace","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"pU4Dm76RJEjtZcereRpJ","title":"ReplaceRegexp","pathname":"/data-transformation/formulas/string-functions/replaceregexp","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"gASj7e416JSmY0QzpVbd","title":"Reverse","pathname":"/data-transformation/formulas/string-functions/reverse","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"cfuG1S6Lz1FXASu1smhm","title":"Right","pathname":"/data-transformation/formulas/string-functions/right","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"WZXe3XcKRZI6o4MgzuL9","title":"Spaces","pathname":"/data-transformation/formulas/string-functions/spaces","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"KOsuzx1DX5TIY41FswEf","title":"Split","pathname":"/data-transformation/formulas/string-functions/split","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"wCe2ykKF85k2cmdmEdM1","title":"SplitRegexp","pathname":"/data-transformation/formulas/string-functions/splitregexp","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"35xr0tDB0ok9khLoWoRa","title":"StartsWith","pathname":"/data-transformation/formulas/string-functions/startswith","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"LXV1sONYH5IyrNkxzhQQ","title":"StartsWithRegexp","pathname":"/data-transformation/formulas/string-functions/startswithregexp","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"GXoxcWTrCCga8eUecsMo","title":"Stuff","pathname":"/data-transformation/formulas/string-functions/stuff","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"wlPCkkrgPeNXKS87skSG","title":"Substring","pathname":"/data-transformation/formulas/string-functions/substring","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"HchBgfc7t7dkwjZdnkuK","title":"SubstringDelimiter","pathname":"/data-transformation/formulas/string-functions/substringdelimiter","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"3rEY5s3mQahyHxxJebKI","title":"SubstringRegexpDelimiter","pathname":"/data-transformation/formulas/string-functions/substringregexpdelimiter","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"KjF5041juYlXcJIvHiz1","title":"Trim","pathname":"/data-transformation/formulas/string-functions/trim","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"691EU6YfLeT7DNKta8Rr","title":"Upper","pathname":"/data-transformation/formulas/string-functions/upper","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"String Functions"}]},{"id":"gvmDS4RSyf4HEollJKey","title":"Date & Time Functions","pathname":"/data-transformation/formulas/date-and-time-functions","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"}]},{"id":"824p2UKN1NHwv8RprudD","title":"Date","pathname":"/data-transformation/formulas/date-and-time-functions/date","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"MTbgkRTgCAkgMriN3OUp","title":"DateAdd","pathname":"/data-transformation/formulas/date-and-time-functions/dateadd","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"awXv6dTwwoSQ0Et02rsX","title":"DateAdd","pathname":"/data-transformation/formulas/date-and-time-functions/dateadd-1","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"wTPcd72GcQlnFgVxmqg5","title":"DateDiff","pathname":"/data-transformation/formulas/date-and-time-functions/datediff","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"K1wX6zucUyLgX9gcMsRT","title":"DateDiff2","pathname":"/data-transformation/formulas/date-and-time-functions/datediff2","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"ig4WJEPIsixykIpzIflp","title":"DateFromParts","pathname":"/data-transformation/formulas/date-and-time-functions/datefromparts","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"RBl6wtKVrAbDzjvyby7b","title":"DateTime","pathname":"/data-transformation/formulas/date-and-time-functions/datetime","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"Tj0MJJ94zJEdDrMgUjm1","title":"DateTimeFromParts","pathname":"/data-transformation/formulas/date-and-time-functions/datetimefromparts","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"H5BqJ4baVdrDNWzqHuj7","title":"DateTrunc","pathname":"/data-transformation/formulas/date-and-time-functions/datetrunc","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"enhFt2IAGXdPM9tcf1SG","title":"DayName","pathname":"/data-transformation/formulas/date-and-time-functions/dayname","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"Koo4OsANo8NI41vopC6S","title":"DayOfMonth","pathname":"/data-transformation/formulas/date-and-time-functions/dayofmonth","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"K00jEPuefDAzMFtd7plU","title":"DayOfWeek","pathname":"/data-transformation/formulas/date-and-time-functions/dayofweek","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"bQ3BWqbcemaDU2WsxPrr","title":"DayOfYear","pathname":"/data-transformation/formulas/date-and-time-functions/dayofyear","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"cfLaUD8rMPXYHarJe9KP","title":"Hour","pathname":"/data-transformation/formulas/date-and-time-functions/hour","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"6xMSt0qLKSaubSvRuKIJ","title":"Minute","pathname":"/data-transformation/formulas/date-and-time-functions/minute","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"hXPBYX2BnYkqIjVI97C1","title":"Month","pathname":"/data-transformation/formulas/date-and-time-functions/month","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"wasa3zbIOzR54lQNb7JU","title":"MonthName","pathname":"/data-transformation/formulas/date-and-time-functions/monthname","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"zyyVUxXN0ph8DB5ORswj","title":"Now","pathname":"/data-transformation/formulas/date-and-time-functions/now","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"ME21cSIZ2TlpZmtYjma5","title":"Quarter","pathname":"/data-transformation/formulas/date-and-time-functions/quarter","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"og5skoie7oSzP5XZIdS1","title":"Second","pathname":"/data-transformation/formulas/date-and-time-functions/second","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"UL1aiJfDF0yqLUhcEkev","title":"Time","pathname":"/data-transformation/formulas/date-and-time-functions/time","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"mKVNWzvneKCcq2Y9YtDd","title":"TimeFromParts","pathname":"/data-transformation/formulas/date-and-time-functions/timefromparts","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"HV1zQkLrU9uQE284Vqy1","title":"Today","pathname":"/data-transformation/formulas/date-and-time-functions/today","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"ElSvA5RtqajHrzo8smO9","title":"Week","pathname":"/data-transformation/formulas/date-and-time-functions/week","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"jnsDpLMxg962Boy5FVNd","title":"Year","pathname":"/data-transformation/formulas/date-and-time-functions/year","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Date & Time Functions"}]},{"id":"eNok8JuFsW8xWpk8iym7","title":"Aggregate Functions","pathname":"/data-transformation/formulas/aggregate-functions","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"}]},{"id":"r4IQBxjY6usnt7oYyUfl","title":"Array","pathname":"/data-transformation/formulas/aggregate-functions/array","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"99l42nX1rjeNPIhggQ2r","title":"ArrayIf","pathname":"/data-transformation/formulas/aggregate-functions/arrayif","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"oQj3PZdyHaO9FWTPQhcw","title":"Avg","pathname":"/data-transformation/formulas/aggregate-functions/avg","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"jEzjGZiqQpg4Mmlx31eV","title":"AvgIf","pathname":"/data-transformation/formulas/aggregate-functions/avgif","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"FbZpxKSWATVGeqeFNnPO","title":"Count","pathname":"/data-transformation/formulas/aggregate-functions/count","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"FI6HAl83vXuqnxkWxXl9","title":"CountA","pathname":"/data-transformation/formulas/aggregate-functions/counta","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"nZFm6SQ9Ewks0a29pW81","title":"CountIf","pathname":"/data-transformation/formulas/aggregate-functions/countif","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"4oJgK7QWlpkdlJRs1SII","title":"CountUnique","pathname":"/data-transformation/formulas/aggregate-functions/countunique","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"QGSdwwWxvU5iVLkxABGu","title":"Max","pathname":"/data-transformation/formulas/aggregate-functions/max","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"IRUH6CbXMpg0NbjOaVL4","title":"MaxIf","pathname":"/data-transformation/formulas/aggregate-functions/maxif","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"QAvvq5XBLKvxYRWR1PBr","title":"Median","pathname":"/data-transformation/formulas/aggregate-functions/median","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"lx0ryDLS22Jxbrp3tOKr","title":"MedianIf","pathname":"/data-transformation/formulas/aggregate-functions/medianif","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"axtqMpO07zEmLlK9dLX1","title":"Min","pathname":"/data-transformation/formulas/aggregate-functions/min","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"fdNnBxoYQgmuf4pkNijX","title":"MinIf","pathname":"/data-transformation/formulas/aggregate-functions/minif","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"hTblj7vSGb1t5J6Y60Vj","title":"Mode","pathname":"/data-transformation/formulas/aggregate-functions/mode","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"iofZXwxWcoufqG9CzWYF","title":"ModeIf","pathname":"/data-transformation/formulas/aggregate-functions/modeif","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"aPaghE88eF31EbsDeqN8","title":"Percentile","pathname":"/data-transformation/formulas/aggregate-functions/percentile","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"YTSa1Q3mjQ735PtbYvPh","title":"Quartile","pathname":"/data-transformation/formulas/aggregate-functions/quartile","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"nZ3XVqjTK3xisknQiUrm","title":"StdDev","pathname":"/data-transformation/formulas/aggregate-functions/stddev","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"dLNLNN6aVHBKWLiGMBeg","title":"StdDevIf","pathname":"/data-transformation/formulas/aggregate-functions/stddevif","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"A2xvcxsWAvCIpspIvqAh","title":"Sum","pathname":"/data-transformation/formulas/aggregate-functions/sum","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"e6KcyDMSqD0WIHHnbBf7","title":"SumIf","pathname":"/data-transformation/formulas/aggregate-functions/sumif","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"jlZxxy6qZ7e9AggXL2E2","title":"SumProduct","pathname":"/data-transformation/formulas/aggregate-functions/sumproduct","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"is9sz9WFwZEODw0hTew3","title":"Variance","pathname":"/data-transformation/formulas/aggregate-functions/variance","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"PlSBho7rRcwv0ry1qn8t","title":"VarianceIf","pathname":"/data-transformation/formulas/aggregate-functions/varianceif","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Aggregate Functions"}]},{"id":"PaH9EcYoKye4aAm8ZiWR","title":"Conversion Functions","pathname":"/data-transformation/formulas/conversion-functions","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"}]},{"id":"WM18FwhIt5KeoNZbBOj1","title":"ToArray","pathname":"/data-transformation/formulas/conversion-functions/toarray","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Conversion Functions"}]},{"id":"6vEZl9TC7kkrLigbCg1c","title":"ToBoolean","pathname":"/data-transformation/formulas/conversion-functions/toboolean","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Conversion Functions"}]},{"id":"b4ZGj5dvqSkOgoMhOOpZ","title":"ToDate","pathname":"/data-transformation/formulas/conversion-functions/todate","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Conversion Functions"}]},{"id":"d1oBjkT8CB8N3Q8VETrP","title":"ToDateTime","pathname":"/data-transformation/formulas/conversion-functions/todatetime","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Conversion Functions"}]},{"id":"Vs0Z1fhU0Zqlk2hKnXnv","title":"ToDecimal","pathname":"/data-transformation/formulas/conversion-functions/todecimal","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Conversion Functions"}]},{"id":"H4aPEm7RBBLQWv8K6OyD","title":"ToInteger","pathname":"/data-transformation/formulas/conversion-functions/tointeger","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Conversion Functions"}]},{"id":"P9LNC3qd6D4xjmQ8q6ST","title":"ToObject","pathname":"/data-transformation/formulas/conversion-functions/toobject","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Conversion Functions"}]},{"id":"LEETwBeLAEnwNatzwBGN","title":"ToTime","pathname":"/data-transformation/formulas/conversion-functions/totime","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Conversion Functions"}]},{"id":"Kenlg93c1YV4UTZqWDMN","title":"ToString","pathname":"/data-transformation/formulas/conversion-functions/tostring","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Conversion Functions"}]},{"id":"8CBx6YEOCAM7syiQ16yo","title":"Misc Functions","pathname":"/data-transformation/formulas/misc-functions","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"}]},{"id":"EdwNQDcBcl0ktD9JgoAu","title":"At","pathname":"/data-transformation/formulas/misc-functions/at","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Misc Functions"}]},{"id":"xxtnyY9HVqU9SoNlCWWx","title":"IsMissing","pathname":"/data-transformation/formulas/misc-functions/ismissing","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Misc Functions"}]},{"id":"LBh3BS84ppzfuzzwMBBZ","title":"RowNumber","pathname":"/data-transformation/formulas/misc-functions/rownumber","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Misc Functions"}]},{"id":"uBRgZTmZdkGsB5w72cnu","title":"Random","pathname":"/data-transformation/formulas/misc-functions/random","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Misc Functions"}]},{"id":"TWSkNmq9gWCebIm8r456","title":"If","pathname":"/data-transformation/formulas/misc-functions/if","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Misc Functions"}]},{"id":"AY7YAPNyuehNJfHzdWcn","title":"Coalesce","pathname":"/data-transformation/formulas/misc-functions/coalesce","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Misc Functions"}]},{"id":"mG0i6sDGQ67pKvu7fwOv","title":"True","pathname":"/data-transformation/formulas/misc-functions/true","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Misc Functions"}]},{"id":"gF5K5UPfo6RiRp87i5x0","title":"False","pathname":"/data-transformation/formulas/misc-functions/false","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Misc Functions"}]},{"id":"2gXrDUIvY1aS3KT4mRpn","title":"Null","pathname":"/data-transformation/formulas/misc-functions/null","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Misc Functions"}]},{"id":"jhqJsBaQ8qpIaExas1q0","title":"$target","pathname":"/data-transformation/formulas/misc-functions/usdtarget","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"},{"label":"Misc Functions"}]},{"id":"WhoDERYRbZEXFbxoytjh","title":"Window Functions","pathname":"/data-transformation/formulas/window-functions","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"}]},{"id":"sfKGB4Dkbfk4yw8ENJ8U","title":"Custom Functions","pathname":"/data-transformation/formulas/custom-functions","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"}]},{"id":"z4R3KPv7W27jPJ8s0FwI","title":"Data Types","pathname":"/data-transformation/formulas/data-types","siteSpaceId":"sitesp_4w7pJ","description":"Supported data types and conversion variants between them","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"}]},{"id":"u00zrOu7upfbzzxxjOPq","title":"Supported Date Parts","pathname":"/data-transformation/formulas/supported-date-parts","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"}]},{"id":"FPFo8MsEMnu9Q1P2J8PL","title":"Regex: List of Tokes","pathname":"/data-transformation/formulas/regex-list-of-tokes","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Data Transformation"},{"label":"Formulas"}]},{"id":"iHYhsmeynI8aay1BeiUr","title":"Plans, Subscriptions, and Credits","pathname":"/pricing-and-billing/plans-subscriptions-and-credits","siteSpaceId":"sitesp_4w7pJ","description":"Tomat is thrilled to announce new paid subscription plans to elevate your data analytics experience.","breadcrumbs":[{"label":"PRICING & BILLING"}]},{"id":"A2KXEWWaGJmUIwLiOoFZ","title":"Connectors","pathname":"/integrations/connectors","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Integrations"}]},{"id":"mjIPg35PJiYvfPIbETve","title":"Data Storages","pathname":"/integrations/connectors/data-storages","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Integrations"},{"label":"Connectors"}]},{"id":"wiz1434f09YSI3fhi4Tq","title":"PostgreSQL","pathname":"/integrations/connectors/data-storages/postgresql","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Integrations"},{"label":"Connectors"},{"label":"Data Storages"}]},{"id":"zEyYHiEYHsgme9pXagin","title":"Snowflake","pathname":"/integrations/connectors/data-storages/snowflake","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Integrations"},{"label":"Connectors"},{"label":"Data Storages"}]},{"id":"Vwk3hHzmnJjnSJryzWOl","title":"Data Sources","pathname":"/integrations/connectors/data-sources","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Integrations"},{"label":"Connectors"}]},{"id":"5wOBfB32CFHVdnoxIJ9z","title":"Merge Columns","pathname":"/tutorials/merge-columns","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Tutorials"}]},{"id":"7kLppR2xNl3qT0G3ksUf","title":"Join Types","pathname":"/tutorials/join-types","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Tutorials"}]},{"id":"EPhpeR7OYiGlr0wIOSqS","title":"Union Introduction","pathname":"/tutorials/union-introduction","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Tutorials"}]},{"id":"myNSfkzN6dIxu3yQmpJx","title":"Window Functions","pathname":"/tutorials/window-functions","siteSpaceId":"sitesp_4w7pJ","description":"Calculates a window function operates on a group (“window”) of related rows","breadcrumbs":[{"label":"Tutorials"}]},{"id":"edFT0UcjM5hGiDdpyavz","title":"What is Unpivot?","pathname":"/tutorials/what-is-unpivot","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Tutorials"}]},{"id":"dSIpu94Wbi6rb9LcnoG2","title":"JSON Format Tutorial","pathname":"/tutorials/json-format-tutorial","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Tutorials"}]},{"id":"77edPzNawWvyWEzm9oVC","title":"Using Regex","pathname":"/tutorials/using-regex","siteSpaceId":"sitesp_4w7pJ","breadcrumbs":[{"label":"Tutorials"}]}]}