Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've searched other issues similar to this one, but I have not found a solution that solves the issue I am facing at the moment.
My job writes out data in JSON format to a file via a tFileOutputJSON component. It then open the file using a tFileInputJSON to read the data out of the file. Both components use the same schema.
The job looks like this:
The output of the tFileOutputJSON_1 looks like this:
{ "data": [ { "RowId": "0", "WorksheetIndex": 16, "Value": "504353", "SheetColumn": "A", "SubjectId": 0, "WorksheetName": "LookUps" }, { "RowId": "0", "WorksheetIndex": 16, "Value": "Tolle, Sebastian", "SheetColumn": "B", "SubjectId": 0, "WorksheetName": "LookUps" }, { "RowId": "0", "WorksheetIndex": 16, "Value": null, "SheetColumn": "CI", "SubjectId": 0, "WorksheetName": "LookUps" }, { "RowId": "0", "WorksheetIndex": 16, "Value": null, "SheetColumn": "CJ", "SubjectId": 0, "WorksheetName": "LookUps" } ] }
The mapping for tFileInputJSON_1 looks like this:
And the resulting output from running the job ends with this error:
I appreciate any and all help I can get on this.
Thanks very much vapukov. I appreciate your help.
Thanks very much vapukov. I appreciate your help.