Hi there
Could someone perhaps tell me why rows would be read into a hashed file but no output is sent out of the hashed file stage again ?
I have an ODBC connector connecting to an Excel spreadsheet. I am using the following USER-DEFINED query in the ODBC stage:
SELECT "SchemeNumber", "BrokerGroup", "BrokerSize" FROM "Exceptions$" where "SchemeNumber" <> ''; (PRIMARY INPUT)
SELECT "SchemeNumber", "BrokerGroup", "BrokerSize" FROM "Exceptions$" (REFERENCE INPUT)
This data then equals 7 rows which go into the hashed file. The hashed file is then supposed to output these 7 rows to a transformer where i use the input of some of the columns for the derivations. However, when I run the job, the rows from the ODBC to the hashed file is fine, but ZERO rows are output from the hashed file into the Transformer.
Any idea why this could be happening ?
Thanks!
Barbara
No output from Hashed file into transformer
Moderators: chulett, rschirm, roy
No output from Hashed file into transformer
-------------------------
https://www.ssa.co.za
https://www.ssa.co.za
Re: No output from Hashed file into transformer
if your lookup condition does not match from reference with stream, you have that issue, please check the values in keys are matching to get output.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I've never sketched what my job looks like so please bare with me here !
ODBC
Stage
reading from ------- Hashed File ---------- Transformer (lookup)
an Excel
S/sheet
I do think that it may be a problem with the input stream reference. Reason is that if I put these stages into a separate test job, then there is no problem ... so I do not believe that it is the name of my hashed file or such like ... what do I have to look out for though when using a lookup? Do the columns have to be the same data type and length ? If so, that would be strange because I have more than one lookup and neither of them matches the data type and length precisely ???
Please let me know if this is ok ... (the sketch I mean and that I've explained myself correctly. It must be extremely frustrating when people don't give enough detail)
Kind regards,
Barbara
email: barbaraohlss@gmail.com
ODBC
Stage
reading from ------- Hashed File ---------- Transformer (lookup)
an Excel
S/sheet
I do think that it may be a problem with the input stream reference. Reason is that if I put these stages into a separate test job, then there is no problem ... so I do not believe that it is the name of my hashed file or such like ... what do I have to look out for though when using a lookup? Do the columns have to be the same data type and length ? If so, that would be strange because I have more than one lookup and neither of them matches the data type and length precisely ???
Please let me know if this is ok ... (the sketch I mean and that I've explained myself correctly. It must be extremely frustrating when people don't give enough detail)
Kind regards,
Barbara
email: barbaraohlss@gmail.com
-------------------------
https://www.ssa.co.za
https://www.ssa.co.za
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: