trevor2524
10-19-2023, 07:50 AM
Hello,
Need a little help as I have about 90 Json files i need to extract information from to a new format. On the example is a portion of a sample Json file that I am using. The expected outcome page is how the information should look after the reformat. On the Json file the only information I'm looking to grab is the Name, Value and the Machines associated with those two values. If no machines are listed, it would just be blank as row 1 on the expected outcome sheet shows. Any help is greatly appreciated.31120
Need a little help as I have about 90 Json files i need to extract information from to a new format. On the example is a portion of a sample Json file that I am using. The expected outcome page is how the information should look after the reformat. On the Json file the only information I'm looking to grab is the Name, Value and the Machines associated with those two values. If no machines are listed, it would just be blank as row 1 on the expected outcome sheet shows. Any help is greatly appreciated.31120