ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions.
Learn more here
So with the help of this post, the reason for extra delimiter is that the data formatted twice - in JSON Build Tool and Output Data Tool.
Instead of using JSON as File Format in Output Data Tool, just simply change to CSV, use \0 (null) as delimiter and uncheck 'First Row Contains Field Names'.