Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to Convert Excel in .json

herbert1682
6 - Meteoroid

I have an excel file that has a row of 260920 and columns upto AS. And I need it to convert into a single .JSON file. 

 

Please see both Capture1 how it should look like vs Capture 2 how I received the file. 

 

 

2 REPLIES 2
gawa
15 - Aurora
15 - Aurora

hi @herbert1682 

Please refer to the attached WF how to create JSON by Summarize tool. 

image.png

herbert1682
6 - Meteoroid

Hi how many columns should there be? should I do all the columns in the formula? 

 

Capture json2.PNGCapture json1.PNG

Labels