Marimuthu86
New Contributor II
Joined 8 years ago
User Profile
User Widgets
Contributions
Transpose data from Excel
HI, Could someone tell me how to transpose data from excel. My Excel input has Pivot data, i need to transform everything to rows. I started with File reader and then used Excel parser to define the row and column, but not sure how to transpose data. Please suggest. Thanks, Muthu5.8KViews0likes4CommentsRe: Error while using Excel Parser
Hi Shankar, Even after changing column names, i’m still getting same error. It looks like when we have two columns with same header text(name), the snap throws out error. If there any solution to sort these kind of scenario? Or is this a limitation in tool? Please suggest. Thanks, Muthu3.1KViews0likes1CommentRe: Issues in reading Nested Json file
Hi Shankarao, Thanks much for your inputs, it works now. Can you also please have a look at below thread and suggest me with the solution. I posted below thread for issue with highly complex nested Json file. I tried a lot but could not solve it. Convert Nested Json file to Excel Designing Pipelines Yes, along with Transcript, i would need to split all levels inside the file. For each level of split, i’m forced to use multiple JSON Splitter. Attaching the full version of file along with pipeline that i created. Could you please help me out with the steps to read this JSON file and write output to Excel format. Test-Full_2018_09_08.slp (25.9 KB) Arno_Sample1.txt (1.9 MB) Would Appreciate any help that you provide here. Thanks Muthu3.4KViews0likes0CommentsIssues in reading Nested Json file
Hi, I tried executing the example for Json Splitter provided in their home page, but the results i’m getting does not match with what they provided in their page. Could someone please correct me if i am wrong somewhere. SamplePipeline.slp (6.6 KB) ExpectedResult.xlsx (8.4 KB) Thanks, Muthu4.9KViews0likes2CommentsRe: Convert Nested Json file to Excel
Yes, along with Transcript, i would need to split all levels inside the file. For each level of split, i’m forced to use multiple JSON Splitter. Attaching the full version of file along with pipeline that i created. Could you please help me out with the steps to read this JSON file and write output to Excel format. Test-Full_2018_09_08.slp (25.9 KB) Arno_Sample1.txt (1.9 MB)6.8KViews0likes0CommentsConvert Nested Json file to Excel
Hi, I’m working on a requirement to convert Nested Json file to .xls format, but facing some bottlenecks in getting required output. The output shows list of values in cells instead of breaking into multiple rows.Would someone be able to help me out here ? input.txt (2.1 KB) currentoutput.xlsx (17.4 KB) I have attached both Input and pipeline files here. Please assist Thanks, Muthu11KViews0likes3Comments