What data type are you joining on?
Is that a string by any chance?
Yes, its a string. Does that make any difference? It shouldn't, right?
It could, unfortunately.
Close to release we discovered an issue when in certain situations join on string might not produce matches. Fix didn't make it into 10.0 and is now tracked for 10.0.1.
Would you mind submitting support case with details? Mention me and ask to send case directly to dev team (ie me).
Here are the case details. Thanks.
Case# 02276269: Cross joins between a csv source and a web connector is not showing data [ ref:_00D30XvE.
Sent from my iPhone