I have this error when trying to merge sync a table. One of the row has 159 fields, and the second row has 160 fields. Is there any way to suppress or disable this error. Let me know if you need more info on that.
Explain how you'd merge a 160 fields stream into a 159 fields table?
Ok, seriously now, add more detail to the question. But the basics is that both sides must have the same number of fields. What are you using to merge? Join? Merge Join? Cross Cartesian?
No, this is a fundamental rule in PDI. just make the streams the same. Work out the difference and either add in the missing column (null if necessary - just make it there) or delete the extraneous column.
if they're not the same, you'll have all sorts of nightmares. This really should be a runtime error IMHO, although at the moment it's only so if you run in safe mode.
Retrieving data ...