Hello All,
I have an excel file which I need to filter few columns through linq query but It’s taking lot of time to read the data, As the data is huge. Is it possible to trim the time.
Hi,
I think it’s probably YES.
Can you share specific sample input and expected output?
Regards,
Hello,
I have shared data and expected output. Please look into it
Banca_Data.xlsx (9.5 MB)
Hi,
How about the following?
dt = dt.DefaultView.ToTable(False,{"INSURANCE_COMPANY","INSURER_RO_NAME","INSURER_DO_NAME","CORPORATE_GROUP_NAME","POLICY_HOLDER_NAME","POLICY_NUMBER","POLICY_START_DATE","POLICY_END_DATE","BASIC_SI_ORIGINAL","INSURED_NAME","CLAIMANT_NAME","CLAIMANT_AGE","CLAIMANT_GENDER","CLAIMANT_RELATION","HOSPITAL_NAME","HOSPITAL_ADDRESS","DATE_OF_ADMISSION","DATE_OF_DISCHARGE","PREAUTH_APP_DATE","CLAIM_INTIMATION_DATE"})
Sample20230931-5.zip (9.5 MB)
Regards,
I tried this method but its taking around 1hr to filter the data.
HI,
Really? In my environment, it takes only 9 sec as the following. For now, can you try the above sample?
Regards,
As I added few more columns to filter it took 2 min for final output.
Thank you so much
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.