Trending questions in Edureka Community

0 votes
1 answer

Excel formula exceeds 8000 characters limit

Using auxiliary columns to divide the formula ...READ MORE

Feb 21, 2023 in Others by narikkadan
• 86,360 points
1,502 views
0 votes
1 answer

How do I change the menu language of Excel Online?

Click on App launcher from any worksheet ...READ MORE

Apr 1, 2022 in Database by gaurav
• 23,580 points
15,606 views
0 votes
0 answers

Using XML with REST API through Azure Datafactory V2

I need to use a REST API ...READ MORE

Feb 15, 2023 in Azure by Damonlang
• 1,230 points
1,766 views
0 votes
1 answer

After exporting ssrs report excel name should have todays date

If you use URL Access to generate the report, ...READ MORE

Feb 9, 2023 in Others by narikkadan
• 86,360 points
2,004 views
0 votes
0 answers

Using SQL Stored Procedure vs Databricks in Azure Data Factory

ADF pipeline must be used to write ...READ MORE

Feb 14, 2023 in Azure by Damonlang
• 1,230 points
1,803 views
0 votes
1 answer

CodeIgniter: Unable to connect to your database server using the provided settings Error Message

 I'm assuming there is something wrong with ...READ MORE

Feb 16, 2022 in Others by Soham
• 9,730 points
17,441 views
0 votes
1 answer

VBA Export as PDF and Save to Location with name as per a Cell in the worksheet

Following is the code that gets generated ...READ MORE

Jan 20, 2023 in Others by narikkadan
• 86,360 points
2,866 views
0 votes
1 answer

Delete all rows in filtered range Except first filtered row in excel VBA

Use a flag to omit first row Sub ...READ MORE

Jan 8, 2023 in Others by narikkadan
• 86,360 points
3,380 views
0 votes
1 answer

Excel VBA search based on cell values into folders and sub-folders to get the file path and data

This will create a listing of all ...READ MORE

Jan 19, 2023 in Others by narikkadan
• 86,360 points
2,899 views
0 votes
1 answer

Why do I have heavy DeserializeSparse phase after EagerKernelExecutes on the multiple GPU training?

The heavy "DeserializeSparse" phase after the "EagerKernelExecutes" ...READ MORE

Feb 17, 2023 in AWS by anonymous
1,650 views
0 votes
0 answers

how to know the day (is it Monday, Tuesday or...) of a specific date in Python

I have a pandas dataframe with one ...READ MORE

Mar 20, 2023 in Python by anonymous
• 990 points

edited Mar 5, 2025 314 views
0 votes
1 answer

How do I get text in a pivot table in excel or google sheets?

Try: =QUERY(QUERY({Data!A:A, Data!Q:S}, "select Col4,max(Col1) ...READ MORE

Feb 6, 2023 in Others by narikkadan
• 86,360 points
2,115 views
0 votes
1 answer

Color specific cell in an xlsx with python

Column B's cells must be iterated through ...READ MORE

Jan 14, 2023 in Others by narikkadan
• 86,360 points
3,107 views
0 votes
1 answer

What VBA code would I use to concatenate cell A2 & B2 in cell C2 and then have it Autofill down the column?

Solution Find the last row. Write a formula to ...READ MORE

Feb 14, 2023 in Others by Kithuzzz
• 38,000 points
1,765 views
0 votes
1 answer

Confused on VBA copy destination

Try this: Sub so75496418AddChart() Dim rng As Range Dim strTypeName ...READ MORE

Feb 20, 2023 in Others by Kithuzzz
• 38,000 points
1,503 views
+1 vote
1 answer

ModuleNotFoundError: No module named 'keras'

Hi@akhtar, I think this problem is related to ...READ MORE

Apr 23, 2020 in Machine Learning by MD
• 95,460 points

edited Aug 11, 2021 by Soumya 46,056 views
0 votes
1 answer

Plot a legend outside of the plotting area in base graphics?

It appears that you are experiencing some ...READ MORE

Sep 8, 2023 in Data Science by anonymous
• 1,420 points
1,809 views
0 votes
1 answer

How to pass parameters in GET requests with jQuery?

Hello, Here is the syntax using jQuery $.get $.get(url, data, ...READ MORE

Apr 28, 2020 in JQuery by Niroj
• 82,800 points
45,868 views
0 votes
1 answer

VBA: My Email .body doesn't concatenate with itself: application-defined or object-defined error

Try this: 'Somewehere declare this string variable Dim incomingHTMLBody ...READ MORE

Feb 16, 2023 in Others by narikkadan
• 86,360 points
1,666 views
0 votes
1 answer

Releasing COM-Object not necessary?

This place has infamously poor Office COM ...READ MORE

Feb 24, 2023 in Others by narikkadan
• 86,360 points
1,318 views
0 votes
1 answer

Get column index from table header in excel

Try it. The StaffDetailsTbl table's headers are ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
• 38,000 points
1,346 views
0 votes
1 answer

Excel formula to get certain cell if the value is between 2 numbers

So, first with vlookup(): A formula so you ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
• 38,000 points
1,858 views
0 votes
1 answer

org.hibernate.exception.SQLGrammarException: could not extract ResultSet

In the stacktrace, there is a line ...READ MORE

Sep 17, 2022 in Database by narikkadan
• 86,360 points
8,229 views
0 votes
0 answers

Convert date from dd-mm-yyyy to yyyy-mm-dd in SQL Server

Given date: DECLARE @Date1 VARCHAR(50) = '30-01-2015' I want ...READ MORE

Aug 18, 2022 in Database by Kithuzzz
• 38,000 points
6,971 views
0 votes
0 answers

How can I get the source code of a Python function?

Suppose I have a Python function as ...READ MORE

Mar 16, 2023 in Python by anonymous
• 990 points

edited Mar 5, 2025 449 views
0 votes
1 answer

VLOOKUP to find weeknumber

Use  ISOWEEKNUM with the dates of the ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
• 38,000 points
1,601 views
0 votes
1 answer

outputting a coloured excel file, python

If you already have an Excel workbook, ...READ MORE

Mar 17, 2023 in Others by Kithuzzz
• 38,000 points
790 views
0 votes
1 answer

Creating sheets with names in column B and assigning data to each sheet for particular name

after the first occurrence of Set sht = ...READ MORE

Feb 13, 2023 in Others by narikkadan
• 86,360 points
1,755 views
0 votes
1 answer

DMZ kind of network design in the AKS

It sounds like you want to implement ...READ MORE

Feb 17, 2023 in AWS by sarit
• 1,830 points
1,579 views
0 votes
1 answer

Removing duplicates in lists

1)To get rid of duplicate items, convert ...READ MORE

Feb 16, 2023 in Python by Rishu
• 300 points
1,618 views
0 votes
1 answer

Excel VBA select range

Please test the following event with adapted ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
• 38,000 points
1,578 views
0 votes
1 answer

VBA Project creating a subroutine for activcell

You have to increase ActiveCell's value by ...READ MORE

Feb 9, 2023 in Others by narikkadan
• 86,360 points
1,915 views
0 votes
1 answer

Error: 'int' object is not subscriptable - Python

int([x[age1]]) You are attempting to access the age1 index ...READ MORE

Feb 16, 2023 in Python by Rishu
• 300 points
1,617 views
0 votes
1 answer

Extract Text after Second Underscore in Excel from right side

The UDF to use. The default separator is ...READ MORE

Feb 3, 2023 in Others by narikkadan
• 86,360 points
2,171 views
0 votes
1 answer

How to copy entire data using row by row and paste to another sheet

Try this: Sub InsertData() Dim ...READ MORE

Feb 5, 2023 in Others by narikkadan
• 86,360 points
2,083 views
0 votes
1 answer

Moving oldest files first from source to destination

You have to change the following line: If ...READ MORE

Feb 24, 2023 in Others by narikkadan
• 86,360 points
1,252 views
0 votes
1 answer

Type mismatch error when referring to array element by location vba

We utilise MID to parse the string. ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
• 38,000 points
1,793 views
0 votes
0 answers

How to handle amazon cognito authentication pop-up using java selenium.

I have a website where post clicking ...READ MORE

Mar 16, 2023 in Selenium by anonymous

edited Mar 5, 2025 386 views
0 votes
1 answer

Iterator should return strings, not bytes (the file should be opened in text mode)

You can read the data of the ...READ MORE

Jan 21, 2023 in Others by narikkadan
• 86,360 points
2,697 views
0 votes
1 answer

How can I verify if a column is only decimal using Power Query M formula?

Try this: = Table.ReplaceValue(#"Changed Type",each [Column4], each ...READ MORE

Feb 13, 2023 in Others by narikkadan
• 86,360 points
1,701 views
0 votes
1 answer

Looping through a folder with Excel files and scraping date from selected cells usin VBA

You record the outcome of your comparison ...READ MORE

Feb 16, 2023 in Others by narikkadan
• 86,360 points
1,565 views
0 votes
1 answer

Trigger a lambda function after a rest api is accessed

To trigger a Lambda function after a ...READ MORE

Feb 16, 2023 in AWS by anonymous
1,585 views
0 votes
0 answers

Why do Python classes inherit object?

Why does the following class declaration inherit ...READ MORE

Mar 16, 2023 in Python by anonymous
• 990 points

edited Mar 5, 2025 368 views
0 votes
0 answers

Retrieve or store results of Gremlin queries within AWS Neptune ML, in IPython Notebook

I need to use Gremlin in a ...READ MORE

Dec 15, 2022 in AWS by Tejashwini
• 5,380 points
1,383 views
0 votes
0 answers

chmod: changing permissions of 'cilocks': Operation not permitted

how do i resolve the error READ MORE

Mar 17, 2023 in Cyber Security & Ethical Hacking by frank

edited Mar 5, 2025 334 views
0 votes
0 answers

Crop a video in python

I am wondering to create a function ...READ MORE

Mar 16, 2023 in Python by anonymous
• 990 points

edited Mar 5, 2025 356 views
0 votes
0 answers

Azure Vnet Private IP Ranges

I don't have experience in networking. I'm ...READ MORE

Feb 15, 2023 in Azure by Damonlang
• 1,230 points
1,597 views
0 votes
1 answer

How to calculate median of unsorted values

In vba code: Dim r As Range Dim result 'Set ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
• 38,000 points
1,238 views
0 votes
0 answers

Convert decimal to binary in python

Is there any module or function in ...READ MORE

Mar 15, 2023 in Python by anonymous
• 990 points

edited Mar 5, 2025 386 views
0 votes
1 answer

Excel Desktop - Office.context.document.settings.get() didn't working

You need to call the saveAsync method of the Office.Settings interface ...READ MORE

Feb 24, 2023 in Others by narikkadan
• 86,360 points
1,194 views