Input the attached file into Alteryx

[Divyaverma2906]

Please input the attached sheet into Alteryx in a readable format. All leads are appreciated.

[FrederikE]

Hey @Divyaverma2906,

This is how you can read such a file: 

A *.csv filetype is perfect for this because it is very basic. "\0" as a delimiter means no delimiter at all. 

[Divyaverma2906]

Appreciate the quick response, but I am still not able to read the data in the input file. I think there is delimited "," used here which is differentiating the fields here

[smoosh]

 I was able to open your file in a similar way as the other poster. The data inside your file is JSON data. When you're looking at the data in a text editor, you're seeing the commas, but in this case, those aren't quite the delimiter you're looking for. 

Try using the settings above, then once open, you can add the JSON parse tool to extract your data. There will be further transformation needed to make it useable for analysis, but the data is there.