![]() ![]() ![]() Enter a keyword and the Join tool searches the Field, Rename, and Description columns to return matches. To do this, you can use the Search box at the top of the Configuration window. This is also really helpful if your dataset contains many fields. The Field column in the table identifies the name of each column in the data and auto-sizes to fit column (field) names without cutting off any text (up to 40 characters).īefore you start updating your fields (columns), you might want to limit your list so that you can perform updates on only a subset of the fields. Each row in the table represents a column in your data. Use the table in the Configuration window to modify the incoming data stream.To delete a join field, select a number on the left-hand side and select the Delete button.Select the dropdown to choose an additional join field, per input.If you need multiple join fields, you can configure an additional row of join fields. Alteryx Designer automatically selects a join field from an input if the same field name was already selected from a different input. Each Input ( Left and Right) has a dropdown list where you can select fields (columns).Blob fields cannot be joined to any other type.Spatial fields cannot be joined, use the Spatial Match tool instead.DateTime field types can only be joined to their exact type.Boolean fields can only be joined to other boolean fields.Numeric fields can only be joined to other numeric fields.String fields can only be joined to other string fields.The error messages might result stating Joins on Double or Float are not recommended due to a rounding error that might occur. The Join tool restricts what field types can be joined together. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |