In this post, we will see a simple feature which can help to clean up output column names generated in JSON Source or XML Source.
Assume that you have following XML as input for XML Source.
<Envelope>
<Body>
<Response>
<column1>xxxxxxx</column1>
<column2>xxxxxxx</column2>
<column3>xxxxxxx</column3>
<column4>xxxxxxx</column4>
</Response>
</Body>
</Envelope>
It may produce long column names as below. To rename output columns use Rename option. Click Search Action > Rename Output Columns
Search for Envelope.Body.Response.
Replace with blank
Check Lock columns after changes
After replacements, your columns may look like this and Lock is checked
Contact Us
If you have more question(s) feel free to contact us via Live chat or email to support@zappysys.com
Comments
0 comments
Please sign in to leave a comment.