Forum Discussion

darshthakkar's avatar
darshthakkar
Valued Contributor
3 years ago
Solved

Sort field names alphabetically in JSON source data

Hi Team, I have my source data coming in JSON format. I want to sort the fields inside the JSON format alphabetically. One way is to use a mapper and arrange them one-one alphabetically but it is a...
  • koryknick's avatar
    koryknick
    3 years ago

    If you are referring to a tab-delimited file, simply replace the field delimiter from a comma to “\t”

del's avatar
del
Contributor III
7 years ago
Copy LinkReport

@ayush.vipul, see if the attached pipeline will assist you as an example. I have simple, arbitrary data in the JSON Generator, but the Mapper and Fixed Width Formatter is the key. The Field Width value in the Formatter is also arbitrary, but needs to be set large enough to handle the longest expected line widths.

Community.5728_2019_07_19.slp (5.8 KB)

  • koryknick's avatar
    koryknick
    Employee
    3 years ago
    Copy LinkReport

    If you are referring to a tab-delimited file, simply replace the field delimiter from a comma to “\t”