Good afternoon,
I would really appreciate if anyone could help me importing a file from a txt with 400.000 lines. I am attaching a sample for the first 4 lines. I am trying to import it but I am recieving an error, and does not let me use "tab" as a delimiter.
Furthermore, I need to format the file into an output, which I am also attaching as the "wanted output".
I will give further details if needed.
Attaching sample and desired output
¡Resuelto! Ir a solución.
Hey @Cesc,
Not a very easy file to parse. the first step I did was to use new line as a delimiter and start working on it from there:
Thank you @IraWatt . Will start from here. Could you share the alteryx file to check how you use the configuration of the tool after the input?
Thank you!
No worries @Cesc, I've attached the example. Let me know if you have any issues :)
@IraWatt ; Almost solved it with your alteryx example and the multiple row formula tool :) Thank you!
Nice one @Cesc ! No worries, must have been a good multi row formula to clean that ! 😄