Import Multiple JSON files from folder in PowerQuery

%3CLINGO-SUB%20id%3D%22lingo-sub-2264069%22%20slang%3D%22en-US%22%3EImport%20Multiple%20JSON%20files%20from%20folder%20in%20PowerQuery%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2264069%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20dynamically%20import%20.json%20files%20as%20they%20are%20placed%20in%20a%20folder%20within%20an%20excel%20in%20order%20to%20track%20metrics.%20I%20can%20import%20a%20singular%20file%20just%20fine%2C%20format%20it%20and%20then%20add%20an%20additional%20column%20which%20generates%20a%20timestamp.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yxsau_0-1617978152382.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F271526iE55AEA1AF03EFA93%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yxsau_0-1617978152382.png%22%20alt%3D%22Yxsau_0-1617978152382.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20when%20I%20try%20to%20replicate%20this%20with%20a%20folder%20of%20.json%20files%2C%20the%20new%20files%20just%20add%20columns%20instead%20of%20rows%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yxsau_1-1617978180034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F271527iC79DA80DCCC36D64%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yxsau_1-1617978180034.png%22%20alt%3D%22Yxsau_1-1617978180034.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20want%20is%20for%20new%20files%20to%20be%20appended%20onto%20the%20bottom%20of%20the%20table%20like%20this%3A%20-%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yxsau_2-1617978512818.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F271529i022679FB875422BE%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yxsau_2-1617978512818.png%22%20alt%3D%22Yxsau_2-1617978512818.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20how%20I%20could%20achieve%20this%3F%20If%20it%20helps%20my%20.json%20file%20is%20formatted%20like%20this%3A%20-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%7B%22accountNumber%22%3A%2276329873%22%2C%22category1%22%3A%22redp%22%2C%22q1%22%3A%22yes%22%2C%22q2%22%3A%22no%22%2C%22q3%22%3A%22yes%22%2C%22q4%22%3A%22yes%22%2C%22q5%22%3A%22yes%22%7D%3C%2FP%3E%3CP%3E%7B%22header%22%3A%22value%22%2C%22header%22%3Avalue%22%7D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2264069%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello, 

 

I'm trying to dynamically import .json files as they are placed in a folder within an excel in order to track metrics. I can import a singular file just fine, format it and then add an additional column which generates a timestamp.

Yxsau_0-1617978152382.png

 

However, when I try to replicate this with a folder of .json files, the new files just add columns instead of rows?

 

Yxsau_1-1617978180034.png

 

What I want is for new files to be appended onto the bottom of the table like this: -

Yxsau_2-1617978512818.png

 

Any ideas how I could achieve this? If it helps my .json file is formatted like this: -

 

{"accountNumber":"76329873","category1":"redp","q1":"yes","q2":"no","q3":"yes","q4":"yes","q5":"yes"}

{"header":"value","header":value"}

 

0 Replies