I have attached a snippet of a data set that I have and i would like to quickly be able to produce the output format (also attached).
I think it might be using the multi field/row formula but I am not sure as it didnt work for me.
All the values are random and you may note that the values change in the output file. My question is more around the format change rather than the values.
Solved! Go to Solution.
A question just like this is asked a few minutes ago and people are giving their solutions. Maybe you can find your solution there: Solved: how to merge rows - Alteryx Community
, Jimmy
Thank you for this! I have updated the question with an updated output if that helps, but I think your solution makes sense to me!
Sorry buddy @h12 , I am unable to understand how the desired output has been generated from the given info. I am unable to figure out the logic by which the output has been generated.
As the data consistency in input and output has been lost and also I think code should be unique,
As per the Output code '32' corresponds to both
Country | Town |
Middlesex | Hounslow |
Leicestershire | Leicester |
while the code '32' doesn't even exist in the input.
Attaching the workflow, incase you are able to tweak it further once you get some hint.
My present output is:
Thank you for this. Sorry the values are random and not consistent therefore I wouldve expected the values to not match.
My main concern was splitting the county and towns up which you have done perfectly! Thank you soo much!