Forum Discussion
Expression.Error: We cannot apply operator .. to types Null and Null
Okay, just to let others know that might have a similar problem I found out the solution. It was my bad, but there were instances where Table B in the merge process that had null values due to an error in the SQL database. Anyway, I replaced all those values and it worked! Thanks to Pete and Jing for the help!
Hi svessari ,
In your main query (that you're trying to merge onto), select the query step before the merge step, go to the dropdown at the top of the column you're trying to merge on and select 'Remove Empty'.
If your merge step still doesn't work, do the same on your sub-query (the one you're trying to add to the main query).
Pete
Hi Pete,
Thanks for the quick reply.
I've removed all empty values in both columns in both tables I'm trying to merge but the Error is still the same. I also tried removing all errors prior to merging in all the columns.
P.S.
I'm working on providing you with the code from the Advanced Editor, it'll be ready soon.
Regards,
Svessari