Trending questions in Edureka Community

0 votes
1 answer

Concatenate or TextJoin Same Cell Multiple Times based on Value in another Cell?

Use the REPT function: =REPT("ABC",4) => ABCABCABCABC ...READ MORE

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

How to get columns from Excel files using Apache POI?

The only way to see all the ...READ MORE

Oct 18, 2022 in Others by narikkadan
 • 86,360 points • 6,734 views
0 votes
1 answer

VBA Excel: Write timestamp to cell on change of another cell

Your request is a little vague, and ...READ MORE

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

Output python dataframe to excel and create a new data_validation column in the exported excel sheet

Use pandas.ExcelWriter with worksheet.data_validation from xlswriter : df["code"] = None items = list(range(1,10)) max_row, max_col = ...READ MORE

Jan 24, 2023 in Others by narikkadan
 • 86,360 points • 2,496 views
0 votes
0 answers

List vs tuple, when to use each?

In Python, when should you use lists ...READ MORE

Mar 15, 2023 in Python by Arya
 • 990 points
edited Mar 5, 2025 • 341 views
0 votes
1 answer

Laravel Excel import using Maatwebsite Excel package with additional columns from View

How to fix: I know you're fed ...READ MORE

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

How to compare 2 cells with delimited items in each and output the difference in items?

The following function would do this for ...READ MORE

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

How to get filtered value of an item as line chart which is absent from column chart in combined chart in Power BI?

By making a new measure that didn't ...READ MORE

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

How to create scatter plot in Tableau from database format?

How to create scatter plot in Tableau ...READ MORE

Feb 23, 2023 in Tableau by Tivadar
edited Mar 5, 2025 • 1,178 views
0 votes
0 answers

Exception in thread "main" java.lang.NoSuchMethodError: com.google.common.base.Preconditions.checkArgument(ZLjava/lang/String;Ljava/lang/Object;)V

While initializing derby with bin/schematool -initSchema -dbType derby it ...READ MORE

Mar 14, 2023 in Others by Prashant
edited Mar 5, 2025 • 363 views
0 votes
1 answer

How to get all Stock list company name and symbol of NSE and BSE with free API?

Check the below link for your answer: http://www.barchartondemand. ...READ MORE

Nov 13, 2022 in Others by narikkadan
 • 86,360 points • 5,569 views
0 votes
1 answer

Excel Get different permutation combination of the values

This work can be completed utilising dynamic ...READ MORE

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

Blazor - ClosedXml - excel cannot open the file beacause the file format or extension is not valid

Changed the following code: function BlazorDownloadFile(filename, bytesBase64) { var ...READ MORE

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

How can I find and replace text in Word using Excel VBA?

Try this code Option Explicit Const wdReplaceAll = 2 Sub ...READ MORE

Oct 15, 2022 in Others by narikkadan
 • 86,360 points • 6,808 views
0 votes
3 answers

How to replace negative numbers in Pandas Data Frame by zero?

 If all your columns are numeric, you ...READ MORE

Dec 16, 2020 in Python by Rajiv
 • 8,870 points • 46,924 views
0 votes
1 answer

How to reference an excel sheet by variable

Identify Worksheet By Partial Name Sub SelectByMonth() ...READ MORE

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

Create a hyperlink to a sheet with same name as the value in the selected cell in Excel through VBA

Credit to Spectral Instance who found the ...READ MORE

Feb 6, 2023 in Others by narikkadan
 • 86,360 points • 1,865 views
0 votes
0 answers

Microsoft Visio Database add-in - Reverse Engineer of Azure Sql Server only showing 'master' Database and no others

I'm trying to target one of our ...READ MORE

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

SQL WHERE ID IN (id1, id2, ..., idn)

Option 1 is the only good solution. Why? Option ...READ MORE

Sep 12, 2022 in Database by narikkadan
 • 86,360 points • 8,218 views
0 votes
1 answer

All Levels of a Factor in a Model Matrix in R

Yes, you can modify the model.matrix() function ...READ MORE

Jun 22, 2023 in Data Analytics by anonymous
 • 1,420 points • 3,429 views
0 votes
1 answer

Fixed position but relative to container

The issue with "fixed" positioning is that ...READ MORE

Jun 28, 2022 in CSS by Edureka
 • 12,730 points • 11,418 views
0 votes
0 answers

Best way to keep Azure Postgres in sync with Azure SQL

For the use of pretty much everything, ...READ MORE

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

Prevent a user from adding or removing row(s) of a Range, but allow him to do so on another Range on the same sheet

The only thing I can offer is ...READ MORE

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

How do I add a column in ALTER TABLE in Hive?

Hi, Yes, we can add column inside a ...READ MORE

May 15, 2019 in Big Data Hadoop by Gitika
 • 65,730 points • 60,657 views
0 votes
0 answers

Input Box Date Validation

I have an update form for my ...READ MORE

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

Name not recognized error in List.Generate

Try this: let Source = < >, columnsToExpand ...READ MORE

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

How to split column into two

Using WRAPSROWS() • Formula used in cell C2 --> Exclusively Applicable To ...READ MORE

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

Excel - count if multiple words are in a cell

Try this using wildcards * with TEXTBEFORE()&nb ...READ MORE

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

Compare 2 columns in same excel sheet in pandas

Try this: import pandas as pd import numpy as ...READ MORE

Dec 16, 2022 in Others by narikkadan
 • 86,360 points • 4,021 views
0 votes
1 answer

How to divide data in excel into 4 columns whose sum is almost equal to 1/4 of the sum of all values/

5049 is the sum of all numbers, ...READ MORE

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

Tableau For Loop a String

In the case of [ { ...READ MORE

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

Excel VBA: Auto increment cell value after each printing

Print Copies of Single Worksheet With Increment Option ...READ MORE

Jan 22, 2023 in Others by narikkadan
 • 86,360 points • 2,414 views
0 votes
0 answers

What is the role of Advanced SME in Azure Synapse Analytics?

I watched a training video for Azure ...READ MORE

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

Why my new server shows numbers in the URL address?

It looks like the URLs for your ...READ MORE

Feb 17, 2023 in AWS by anonymous
 • 1,294 views
0 votes
1 answer

Lock and unlock cells in Excel based on color in all worksheets

The following should function if you actually ...READ MORE

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

ErrorDocument 404 /404.php is not working in .htaccess file in PHP

This is the Content of my .htaccess file is: ErrorDocument ...READ MORE

Jun 21, 2022 in PHP by narikkadan
 • 86,360 points • 1,587 views
0 votes
1 answer

SQL Server Convert Varchar to Datetime

Try this: SELECT CONVERT(Datetime, '2011-09-28 18:01:00', 120) -- ...READ MORE

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

Azure Data Engineer Associate certificate - preparation, Microsoft learn platform

Has anyone tried using Microsoft's online training ...READ MORE

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

Power Query - Find matching contents from multiple other tables

Try entering this code in Powerquery's input ...READ MORE

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

Getting error message about master.sys.sysclsobjs while converting SQL Server database to Azure

I have a database with SQL Server ...READ MORE

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

How to access entire row by cell address or value in excel?

You may accomplish all of this by ...READ MORE

Dec 28, 2022 in Others by narikkadan
 • 86,360 points • 3,452 views
0 votes
1 answer

VBA How do I replace the range with an array in SUMIF

You can't, in my opinion. When you ...READ MORE

Feb 7, 2023 in Others by narikkadan
 • 86,360 points • 1,676 views
0 votes
0 answers

How to delete unwanted artifacts in Azure DevOps

Numerous NuGet packages are created by our ...READ MORE

Dec 13, 2022 in DevOps on Cloud by Edureka
 • 13,740 points • 4,109 views
0 votes
1 answer

how to use the Box-Cox power transformation in R

Yes, you are on the right track ...READ MORE

Jun 22, 2023 in Data Analytics by anonymous
 • 1,420 points • 3,398 views
0 votes
1 answer

Allow alpha numeric values instead of isnumeric

Here's a small Function you could add to your ...READ MORE

Feb 18, 2023 in Others by narikkadan
 • 86,360 points • 1,197 views
0 votes
0 answers

Is Azure DevOps going away?

Could someone tell me whether Azure DevOps ...READ MORE

Feb 16, 2023 in DevOps & Agile by Edureka
 • 12,730 points • 1,301 views
0 votes
2 answers

Sigma code look like this but it’s not working.

ok so u need add a sigma ...READ MORE

Mar 20, 2025 in Python by anonymous
 • 2,495 views
0 votes
0 answers

Function for factorial in Python

How can I compute an integer's factorial ...READ MORE

Feb 15, 2023 in Python by Arya
 • 990 points • 1,272 views
0 votes
1 answer

Excel: How to set a dropdown list cell to fetch list of strings from an API JSON response

The values you wish to display in ...READ MORE

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

Open webpage in fullscreen in Safari on iOS

No, javascript cannot be used to switch ...READ MORE

Nov 4, 2022 in IOS by Rahul
 • 9,690 points • 5,747 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.