This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have an excel file which contains the information of a restaurant orders, what I'm looking for is to group each order with a unique row to make it easier to be observed. Below I attached the picture of the input file which will be as input in the work flow:
And here is the output file which I made it manually and I'm looking to be done by alteryx.
Any idea on how it can be done or any help in that please?
tried to do that but I don't have the choice of Concatenate by, I tried by order number I grouped by and sum by but I don't have the Concatenate by choice. Could you please give me more details on which fields I have to to do that?
In order to view the option to Concatenate by a certain field, you will need to ensure that that field is a string data type. If so, your configuration of the summarize tool will look something like this:
I would go ahead and look at the example workflow attached above ^^^ by @smoskowitz to get you on the right track. This example workflow will not mimic the exact "merge cells" format like in Excel, but you can concatenate the records several ways. The example from @smoskowitz shows the "," separator but her is a list of things you can do to customize the concatenation process:
Start:The character specified will appear at the beginning of the concatenated string. It is left blank by default.
Separator:The character specified will appear in between each value of the concatenated string. The default is a comma,.
End:The character specified will appear at the end of the concatenated string. It is left blank by default.
The start, separator and end elements must be specified for each field an action is being applied to. You can enter any character or string, or leave them blank. Supported escape characters include:\n(new line),\t(tab),\r(carriage return), and\s(white space character).
You can also rename the columns to your liking within the Summarize tool under the "Output Field Name" column for consistency.