Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Reading a JSON file and update values in a List

sreejithmp
8 - Asteroid
‎03-08-2022 01:00 AM

General Question: For updating a json file--> reading it as csv file with no delimiter and then update the rows by identifying the pattern using regx functions and save it as .JSON OR read it as json with name value pair then update the values and save as .JSON which is the correct way.

Labels:
Reply
0 Likes
1 REPLY 1
TheOC
15 - Aurora
15 - Aurora
‎03-08-2022 03:11 AM

hi @sreejithmp 

As always with Alteryx, there are many ways to approach a task, and theres not always a clear cut right answer. My suggestion would be the latter, as it would be easier to troubleshoot if there was a problem with your workflow. Additionally you have the option of using the first method, but extracting the name/value pairs with a json parse tool within Designer.

 

Hope this helps,
TheOC


Bulien
Reply
Labels