Hi Team,
Need some help in parsing the atatched data in right format. Tried Text to Coloumns but failed.
¡Resuelto! Ir a solución.
It looks like JSON so you should use the JSON Parse Tool (alteryx.com)
What settings did you use? could you import it as a data input as a csv?
Thanks Alex, Can you attach the canvas, need to cross check my settings
I am not sure what the issue is, the CrossTab is exactly what I'd use here. You can then reorder / rename fields with a Select tool afterwards.
Thanks Alex