Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i have a problem with the tWriteJSONField-component.
The current job (simplified) looks like this:
tMysqlInput => (tSortRow) => tWriteJSONField => tLogRow
The DB-Input-Data looks like:
These are opening times for clients. My goal is it to build a single json for all opening times per client. Expected Output is:
Instead, what i actually get is:
As you see the client_id does not match the client_id in the openings-json. They are all shifted by one row: The client_id 32 gets the openings from the client 24, client 64 gets the openings from client 32 and so on.
I tried to sort the data with a tSortRow before the tWriteJsonField but it stays the same.
I attached images from the job and the configuration of tWriteJSONField.
Can anyone help me?
Thank you
i have a problem with the tWriteJSONField-component.
The current job (simplified) looks like this:
tMysqlInput => (tSortRow) => tWriteJSONField => tLogRow
The DB-Input-Data looks like:
|id |typ|client_id|dayofweek|from_m|to_m|from_a|to_a|singleday|singlemonth|comment|odd_week|
|=------+---+---------+---------+------+----+------+----+---------+-----------+-------+-------=|
|1640760|a |24 |0 |0000 |0000|0000 |0000|0 |0 | |false |
|1640761|a |24 |1 |0800 |0000|0000 |1830|0 |0 | |false |
|1640766|a |24 |6 |0830 |1300|0000 |0000|0 |0 | |false |
|1640767|a |32 |0 |0 |0 |0 |0 |0 |0 | |false |
|1640768|a |32 |1 |0830 |1830|0 |0 |0 |0 | |false |
...
These are opening times for clients. My goal is it to build a single json for all opening times per client. Expected Output is:
|client_id|openings
|24 |{"openings":}|
|32 |{"openings":} |
Instead, what i actually get is:
|client_id|openings
|32 |{"openings":}|
|64 |{"openings":} |
As you see the client_id does not match the client_id in the openings-json. They are all shifted by one row: The client_id 32 gets the openings from the client 24, client 64 gets the openings from client 32 and so on.
I tried to sort the data with a tSortRow before the tWriteJsonField but it stays the same.
I attached images from the job and the configuration of tWriteJSONField.
Can anyone help me?
Thank you
Hi,
it looks the same. I made a screenshot to show the Job:
As you can see the "client_id" doesn't match the "client_id" in "openings". Only the last one is correct, but the client 62 is then duplicated.
I've used this component before in other Jobs and also never had this problem.
Build-Version: Talend Open Studio ESB 6.1.1.20151214_1327
it looks the same. I made a screenshot to show the Job:
As you can see the "client_id" doesn't match the "client_id" in "openings". Only the last one is correct, but the client 62 is then duplicated.
I've used this component before in other Jobs and also never had this problem.
Build-Version: Talend Open Studio ESB 6.1.1.20151214_1327