massage output so that it will work with etl job