Hi All, I get the following issue while trying to execute sql case statement with excel as data source. - IErrorInfo.GetDescription failed with E_FAIL(0x80004005)
My query is
A.[Id], Case When B.[sId] Is NULL Then ‘New’ Else ‘Existing’ End
from [Current$] A
left Join [Previous$] B On A.[Id] = B.[Id]”
I am just checking if a value of coulmn1 in sheet 1 is available in Column1 of sheet2.
P.S: My production data has 10 columns in each sheet and about 500k records to compare. Existing Vlookup is very slow for business.