Release 9.2Search by CategorySearch by CategoryClick the links below to search the product docs by category (page label).By roleanalystadministratordeveloperBy Alteryx® object typeflowimported_datasetwrangled_datasetcolumnrowdata_typejobuserrecipedictionarysamplelicensepasswordlogudfmacrooutput_objectpublicationreference_datasetBy types of documentationrelease_notesgetting_startedquick_starttaskconceptreferencetroubleshootinghow_touisettingsBy Alteryx UI object typedata_quality_barhistogramdata_gridcolumn_browsercolumn_detailstransform_cardstransform_editorrecipe_panelgrid_optionsjob_resultsadmin_settingspanelConnectivityclouderahortonworkspostgrescentosrhelubuntukerberoshadooprelationalHadoop Componentshivesparkyarnhdfswebhdfshttpfsjobtrackerresource_managersentryrangerkmsComponents and Servicesprofiler_servicedata_servicebatchjobrunnerjob_serviceFile Formatscsvjsonavroparquetexcelgzipbzipsnappytableautdelocal_fileActionsinstallinstallationupgradeuninstallconfigureconfigurationadministrationimportuploaddiscovercleanseenhancebatchdeleteremoveresetproject_managementuser_managementexportdownloadloginregisterregistrationpermissionssecure_impersonationemailofflineAll categoriesreferencedata_analystanalystwrangletasklanguageadministratoradminuifunctionconfiguredeveloperhow_toinstallsettingsconfigurationguidatasetcolumninstallationexampleconnectionhadoopimportapiconceptupgraderelationalrecipeparameteraggregatepivotdata_typeflowdatabasegetting_startedstringrowexportapplicationdateendpointjdbcdeployjobbasicshdfshiveuserapiv4imported_datasetproject_managementarrayconnectdownloaduploadoverviewstepscreatepostgresauthenticationhowtoupdateazurewindowmaths3deleterelease_notesclouderasparknestedsecuritycentosrhelkerberosawscdhdeploymentfeaturepasswordubuntuamazonessentialsconnectorsampleyarnsecure_impersonationhortonworksotherproject_management_tasksresource_managerhdprunning_environmentdata_gridtypemismatcheddataprepaddwranglingnextpreviousdcmigratemissingwrangle_function_ifplanemailrollingoutputwrangle_function_numformatlistappformataveragerun_jobscenariohttpfsjsondiscoverismissingcomparisonpermissionstransformtransformation_uitrigtrigonometrywrangle_transform_deriveauthwebhdfsscheduledata_quality_barwrangle_function_dateformatrunanglecsvconnectivityworkspacemysqlnamenodegetremovessoearly_previewobjectcolumn_browserwrangle_transform_setcleanseenginepatternadmin_settingsparameterssequencewrangle_function_averagecleanse_tasksloginapiv3configlogicaljoinimport_tasksresource-iconwrangle_function_ismissingadlsconvertsearchpublishrecipe_panelregular_expressionstructuring_tasksisnullpiglocal_filenullserviceaccessflow_viewtransform_cardsvalidpanelhistogramdesigner_tooltooleditifwrangle_function_nullfilefilterenableprofilingclientminimumwrangle_function_trimlessondatastoreavrogroupencodingexecutionbackupregexuser_managementadmin_uiurlsumjob_uitrimcolumn_detailsredshiftwrangle_transform_pivotwrangle_function_leftprofilerwrangle_transform_windowv4importedsharingdevelopmentwritewrangle_function_sourcerownumberwrangle_transform_replacejob_resultswrangle_function_isnullismismatchedoauthoauth2outputstimehdiminresetunnestadmin_tasksdatatypestorageisvalidwasbwrangle_transform_deletefindrankcastschedulingiamauthorizationjoin_keysflow_uihyperbolicmetadatamicrosoftphotonplan_uiwrangle_function_suminvalidcountrolepublishingtroubleshootingwrangle_function_absconnection_uifeature_overviewendpointslogicsqltableauarchivenestregisterusersdatabrickssentrylogclienrichment_tasksoutput_objectjobsprojectpopulationssltransformationcompareudfuser_uiregistrationwrangle_function_ismismatchedscriptordersinekmsvisual_profilerwrangle_function_datedata_serviceoutput_uiexponentialoperationalizationrolessharesamplingblendparsemachinerangerunionwrangle_function_powwrangle_function_arraylenhahigh_availabilityimport_uidiscovery_taskssingle_sign-onwrangle_function_roundpatternswrangle_function_lensnowflakeofflinetransform_buildermachinelearningmacroswrangle_function_rollingaveragesourcerownumberemrhyperbolaloggingutf-8wrangle_function_findlearningsqlserveramiutf-16standard_deviationvarianceoperatorsnumformatflowsmaxgroup_bymappingplatformoutputobjectadministrationpdfdataset_uijavareusewrite_settingsintegerlicenseradiansorchestrationwrangle_transform_keepconditionalcopymodepublicationswritesettingsenhanceprofiler_serviceresultsroundmodsessionroundingextractwrangle_transform_headertransform_taskswrangle_function_sqrtavgexample_date_functionssinhsoftwareuser_defined_functionclusteradditionstdevwrangle_function_modwrangle_function_properplan_taskssupportvalidationexample_statistical_functionssorttimezonewrangle_function_stdevarcsinebase_storage_layeroraclewrangle_function_maxwrangle_function_mincountdistinctwrangle_function_sinhcountarecipe_uiconcatenatevarwrangle_transform_aggregatewrangle_transform_splitpostgresqlpublishing_tasksreleasedeviationaggregationfile_systemwrangle_function_datedifexample_list_math_functionsxlsxexcelwrangle_transform_mergecollaboratorexample_numeric_functionsexample_rolling_functions_2ingestionhdinsightarraystomaptriggervalidation_tasksexample_kthlargestdate_functionsmatchesparquetwrangle_transform_dropheaderxlsingestsnippetuser-definedcredit_carddisablestandardizationstandardizecasedata_qualityhttpsearch_arrayshared_with_meworkdaybrowserlimitfrequencygoogleasindatasourceteradatawrangle_transform_renameoperatorreplaceconnectionsexample_comparison_functions1example_percentile_functionsselect_column_valuetokenconversionfloorpowtype_inferencevaluestocolswrangle_function_matcheswrangle_function_radianshome_pagetime_zoneexample_domain_functionsvalidatewrangle_function_asinabsconcatenationdateformatpercentilestatusjobgroupowned_by_merdssalesforcetransformer_pagewrangle_function_domainwrangle_function_subdomainwrangle_transform_settypecosineeditortangentviewerwrangle_function_prevceilinghistorymeanoverridewrangle_function_arrayzipmultiplywrangle_function_expwrangle_function_floorwrangle_function_lnwrangle_function_logwrangle_function_notdividekthlargestsubtractwrangle_function_equalwrangle_function_greaterthanwrangle_function_greaterthanequalwrangle_function_lessthanwrangle_function_lessthanequalwrangle_function_lowerwrangle_function_multiplywrangle_function_notequalwrangle_function_rightifmismatchedvaluewrangle_function_addwrangle_function_ceilingwrangle_function_dividewrangle_function_ifmismatchedwrangle_function_negatewrangle_function_substringwrangle_function_subtractcollapsecollapse_rowmaximumnegatetransform_uiwrangle_function_varwrangle_transform_unnestcorrelationwrangle_function_correlwrangle_function_rangewrangle_function_sumifindexisoutfwrangle_function_mindatebigqueryprogrammingservercolumn_uienrichmentnodetable_settingspattern_profilingrangedesktopglossarylargestmenumetricsadvancedexample_conditional_calculations_functionsexample_date_difference_functionsexample_string_comparison_functionsexample_type_functionsparameterizationwrangle_function_timekthlargestuniqueauthorwrangle_function_modearraylengthschemanewwrangle_function_arraysortwrangle_function_mindateifsyntaxformulaconditionsql_dwtablewrangle_function_datetimechangefailovergzipvfsdata_preparation_toolsdependenciesdockerprivilegerequirementswildcarddataec2datetimetablessuccessverifywrangle_transform_splitrowsgrid_optionsparameter_uiexample_randbetween_and_pi_functionsrankingstartswithgluedetailsdoublemetaphonehideimport_dataoperationalization_tasksrecoverywrangle_function_doublemetaphonedowngrademacropackageunicodepreppreparationtableau_serverunpivotcontacthelpvariablewrangledadls_gen2cacheequalintegratemergewrangle_function_keysmedianpatchschedule_uiwrangle_transform_extractexample_comparison_functions_equalexample_exponentional_functionsexample_if_data_type_validation_functionsexample_nested_functionsexample_replacement_transformspostsettargetarraysortcosecantcotangentsecantzipcoefficientcorreldecimalexample_date_and_time_functionssamlceillogsuser_settings_uicoordinated_universal_timemindaterenameutczipcodearrayindexofexample_comparison_functions2example_type_parsing_functionsexpget_helpmismatchoverridessqrtsubscriptioncertificateplan_viewrightsessionidsubstringanyelseendswithkeysoutlierssearch_and_replacesplitthenuniquewrangle_function_filterobjectbooleanfolderipaddresslogarithmtransposecronleftplatform_portalquartilebuilderdialogpropertiescommunitydistinctdomainexample_statistical_functions_sample_methodlibrary_pagepowerprevprofilesnapshotsubdomainwrangle_function_arraystomapwrangle_function_ipfromintwrangle_function_iptointwrangle_function_weekdaybatchcolumnsnowtodaywrangle_function_anywrangle_function_charwrangle_function_daywrangle_function_hourwrangle_function_inwrangle_function_kthlargestwrangle_function_listwrangle_function_minutewrangle_function_monthwrangle_function_monthnamewrangle_function_nextwrangle_function_secondwrangle_function_unicodewrangle_function_unixtimewrangle_function_yearderivekeeplnlookupmindateifschedulesbase64encodebinarybucketlibraryremovesymbolsremovewhitespacereplace_macrosettypesql_serverwrangle_function_andwrangle_function_arrayconcatwrangle_function_arraycrosswrangle_function_arrayintersectwrangle_function_arrayuniquewrangle_function_base64encodewrangle_function_isvalidwrangle_function_orwrangle_function_removesymbolswrangle_function_removewhitespacewrangle_function_upperabsolute_valuewrangle_function_endswithwrangle_function_fillwrangle_function_rollingsumwrangle_function_startswithwrangle_function_varifcountififmissingifnulllistifquerysumifwrangle_function_averageifwrangle_function_countawrangle_function_countdistinctifwrangle_function_countifwrangle_function_ifmissingwrangle_function_kthlargestifwrangle_function_listifwrangle_function_maxifwrangle_function_minifwrangle_function_rownumberdependencydownstreamexample_rounding_functionsfilter_panelflattenlenlineagerandomread-onlystoresummationtrignometryupstreamnest_jsonworkflowphoneproductionsizinguser_management_uiwrangle_function_suffixcommentgendersamplessocial_security_numberssnsharepointstatesample_uistringgreaterthanstringgreaterthanequalstringlessthanstringlessthanequalwrangle_function_stringgreaterthanwrangle_function_stringgreaterthanequalwrangle_function_stringlessthanwrangle_function_stringlessthanequalaccess_tokencredentialsemptymultipleredundancyschedule_taskstdevisibilitywrangle_function_casewrangle_function_rollingkthlargestwrangle_function_rollingkthlargestuniquewrangle_function_rollingmaxwrangle_function_rollingminwrangle_function_rollingvarwrangle_function_urlparamswrangle_function_weeknumdataflowexactexample_arraylen_and_arrayelementat_functionsexample_date_functions_min_max_and_modeexample_dateif_functionsexample_logical_functionsexample_now_and_today_functionsexample_rolling_date_functionsexample_rolling_functionsexample_string_cleanup_functionsexample_time_zone_conversion_functionsexample_trigonometry_arc_functionsexample_trigonometry_functionsexample_trigonometry_hyperbolic_arc_functionsexample_trigonometry_hyperbolic_functionsexample_two-column_statistical_functionsparameterizeuninstallwrangle_function_exactwrangle_function_isevenwrangle_function_isoddwrangle_function_piwrangle_function_randbetweenwrangle_function_truncgreater_thanintegrationless_thanmove_columnsarrayelementatcombineexample_day_of_functionsfile_formatwrangle_function_arrayelementatwrangle_function_rollingstdevautomationdetect_structurelogoutpushdownarraymergeelementsarrayrightindexofarrayslicedata_admindesigner_functionexample_case_functionsexample_quote_parametermovepeopleputrowswrangle_function_arrayindexofwrangle_function_arraymergeelementswrangle_function_arrayrightindexofwrangle_function_arrayslicewrangle_function_listaveragewrangle_function_listmaxwrangle_function_listminwrangle_function_listmodewrangle_function_listsumwrangle_function_listvarby_exampledatasetsstructurevariablescosenvironmentexample_next_functionschema_validationsfdcsintanazure_databricksemail_addresssql_dbcoshcutip_addresslabelpastepythontanhtransform_editorwrangle_function_countdistinctwrangle_transform_sortdbkey-valueprivilegesus-asciiwindowswrangle_function_denserankwrangle_function_rankdatawarehouseportshare_tasksspecial_charsdb2file_importhotfixjob_monitoringpublishing_actionrollbackrollingmodewrangle_function_rollingmodefile-basedrollingaveragestdevsampstdevsampiftable-basedvarsampvarsampifwrangle_function_stdevsampwrangle_function_stdevsampifwrangle_function_varsampwrangle_function_varsampifwrangle_transform_unpivotarccosinearctangentfillwrangle_function_coswrangle_function_sinwrangle_transform_flattenlocalepreferencesresourcescothcschoptimizesechwrangle_function_coshwrangle_function_tanhdictionaryenrichconverttoutcmiddlenetworkdayswrangle_function_converttoutcwrangle_function_networkdaysoperations_taskspredictive_transformationcompressionfailurehttpsiam_roleparseboolservice_accountwrangle_function_medianwrangle_function_parseboolwrangle_function_percentilewrangle_function_quartileappendapproximatebzipcharfailgeneratehomenest_columns_arraynest_columns_objectsnest_transformationparseintphone_numberstatisticstrainingwrangle_function_parsedatewrangle_function_parseintabfssexample_arrayslice_and_arraymergeelements_functionsmatchmatchingparsefloatswaptimestampusagewrangle_function_parsefloatapproximatemedianbatch_job_runnerdenserankfilterobjectjoin_toolsnotificationspreviewstructuringtopicsexample_arrayindexof_and_arrayrightindexof_functionsexample_base64_encoding_functionsexample_count_functionsexample_extractkv_and_unnest_transformsexample_flatten_and_valuestocols_transformsexample_iptoint_functionexample_pow_and_sqrt_functionsexample_rank_functionsexample_rollingkthlargest_functionsexample_startswith_and_endswith_functionsformattingrelationshiptrustLanguageTransformsFunctionsParametersExamples