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
Before you hit "Table", usually you can check the preview data of it. Can you click the blank white area in a cell and check the table data at bottom? Does this table display correct results after merging?
If the table doesn't have correct results, can you show how you merged two tables?
Best Regards,
Community Support Team _ Jing
Thanks for the reply Jing.
It seems to be correct, apart from in every match there's a row at the bottom with "Error" in every column.
You can see the picture attached, in row 31 there's a correct match, but additionally there's an "error row".
Regards,
Svessari
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
