Trending questions in Edureka Community

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,700 points
901 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
961 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
697 views
0 votes
1 answer

Count duplicate words within string and remove if it occurs less than 10 times

Without some sample data, it's challenging to ...READ MORE

Feb 21, 2023 in Others by narikkadan
• 63,600 points
652 views
0 votes
1 answer

Excel VBA Scheduled message pop up box reminder

What exactly does W11 contain? In Excel, ...READ MORE

Feb 3, 2023 in Others by narikkadan
• 63,600 points
1,422 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,260 points
14,747 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
913 views
0 votes
0 answers

Axios, is it slower to auto catch error responses (such as 404)?

Just out of curiosity, the default setting ...READ MORE

Feb 14, 2023 in AWS by Ashwini
• 5,430 points
880 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
• 63,600 points
843 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
• 63,600 points
1,956 views
0 votes
0 answers

Testing & Deploy Azure Data Projects

As an Azure developer and data engineer, I enjoy automating cloud deployments and testing.  I'm currently working with a number of Azure resources, including SQL Server, PowerBI, Azure Data Factory, Azure Data Lake Storage, and Azure Data Lake Analytics. Doing some research I've found a bunch ...READ MORE

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

Fill a FileDialog from another macro

Add an optional parameter to UpgradeEngine - something like: Sub ...READ MORE

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

R: Generate Random Numbers with "floor" and "runif"

It looks like there's a small issue ...READ MORE

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

Java 11 JDK for Windows 7 32-bit system

I wanted to install Java 11 on ...READ MORE

Apr 21, 2022 in Java by Rahul
• 3,380 points
4,678 views
0 votes
1 answer

How to deploy Airflow to production being agnostic to Cloud providers?

Yes, deploying Airflow using Docker is a ...READ MORE

Feb 17, 2023 in AWS by anonymous
783 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
785 views
0 votes
1 answer

How to use plotly in R shiny

Here's a corrected version of your code: # ...READ MORE

Sep 8, 2023 in Data Science by anonymous
• 1,420 points
955 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
774 views
0 votes
1 answer

Setting mime type for excel document

I assume application/vnd.ms-excel is the standard MIME ...READ MORE

Apr 4, 2022 in Database by gaurav
• 23,260 points
14,595 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
• 63,600 points
1,279 views
0 votes
1 answer

Calling AWS ELB public DNS from AWS EC2 client. How much do I get charged?

If you are calling an AWS Elastic ...READ MORE

Feb 17, 2023 in AWS by sarit
• 1,830 points
759 views
0 votes
0 answers

Is Azure DevOps free?

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

Feb 16, 2023 in DevOps & Agile by Edureka
• 12,700 points
806 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
995 views
0 votes
1 answer

How can I stop my vba code from giving me an error 424?

Object Variables in Loops The main issue was ...READ MORE

Feb 9, 2023 in Others by narikkadan
• 63,600 points
1,077 views
0 votes
1 answer

Dropdown list circular reference Excel/VBA

Try this: Private Sub Workbook_SheetChange(ByVal Sh As Object, ...READ MORE

Feb 18, 2023 in Others by narikkadan
• 63,600 points
688 views
0 votes
1 answer

xlsxwriter formatting is corrupting my excel file

The problem is that while attempting to ...READ MORE

Dec 28, 2022 in Others by narikkadan
• 63,600 points
2,934 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
• 63,600 points
687 views
0 votes
0 answers

What is Artifacts in Azure DevOps?

Could someone tell me what are Artifacts ...READ MORE

Feb 16, 2023 in DevOps & Agile by Edureka
• 12,700 points
784 views
0 votes
1 answer

How to set a column as a range variable as long as there is data in it?

Try this: Dim rng As Range Set rng = ...READ MORE

Feb 16, 2023 in Others by narikkadan
• 63,600 points
760 views
0 votes
0 answers

which phase of software production are the focus of devops?

Which phase(s) of software products are the ...READ MORE

Dec 22, 2022 in DevOps & Agile by Edureka
• 13,670 points
3,031 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
974 views
0 votes
1 answer

Multiplication of all numbers in a cell by a specific number

With ms365, try: The formula in B1: =MAP(A1:A3,LAMBDA(x,TE ...READ MORE

Feb 21, 2023 in Others by narikkadan
• 63,600 points
537 views
0 votes
1 answer

How to build a Python project for a specific version of Python?

To build a Python project for a ...READ MORE

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

How to hide blank rows in an excel form if they are blank

If an empty row should be defined ...READ MORE

Feb 13, 2023 in Others by narikkadan
• 63,600 points
881 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
• 63,600 points
1,744 views
0 votes
1 answer

Excel: Get text between two characters

Try this: =SUBSTITUTE(TEXTAFTER(A1:A4,"/",-1),"'","") Here is the output:  Similarly to get ...READ MORE

Feb 14, 2023 in Others by Kithuzzz
• 38,000 points
834 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
• 63,600 points
1,130 views
0 votes
0 answers

How to decrypt a password from SQL server?

Use the following SQL Server 2000 query: select ...READ MORE

Aug 11, 2022 in Database by Kithuzzz
• 38,000 points
8,888 views
0 votes
0 answers

Azure SQL and Visio 2019 Plan 2 Database Reverse engineering wizard Fails

I'm trying to reverse-engineer an Azure SQL ...READ MORE

Feb 14, 2023 in Azure by Damonlang
• 1,230 points
839 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
• 63,600 points
1,123 views
0 votes
0 answers

What is the difference between Azure DevOps and AWS DevOps?

Could someone perhaps explain how Azure DevOps ...READ MORE

Feb 16, 2023 in DevOps & Agile by Edureka
• 12,700 points
754 views
0 votes
1 answer

Do Until replay tree times

Clean Data: Apply Consistent Formatting in Columns Option ...READ MORE

Feb 13, 2023 in Others by narikkadan
• 63,600 points
862 views
0 votes
1 answer

Put text body above the pasted range

Set x before you paste. x = doc.Range.End ...READ MORE

Feb 20, 2023 in Others by Kithuzzz
• 38,000 points
558 views
0 votes
0 answers

Insert multiple rows into single column

I am having problems adding numerous data ...READ MORE

Sep 4, 2022 in Database by Kithuzzz
• 38,000 points
1,546 views
0 votes
1 answer

Highlight closest cell value in a table

Conditional formatting will be used to highlight ...READ MORE

Feb 18, 2023 in Others by narikkadan
• 63,600 points
642 views
0 votes
1 answer

Sublist on Excel

Try using this formula in sheet 1  =FILTER(Sheet2!B3:B8,Sheet2!E3:E8<2) The ...READ MORE

Feb 21, 2023 in Others by narikkadan
• 63,600 points
507 views
0 votes
1 answer

Export from r in excel

Try this: library(xlsx) write.xlsx(x, file, sheetName="Sheet1") READ MORE

Feb 13, 2023 in Others by narikkadan
• 63,600 points
853 views
0 votes
0 answers

Correlation and heatmap for dataset having numerical and categorical variables

I want to measure the correlation and ...READ MORE

Mar 1, 2023 in Data Science by Chitrolekha

edited Mar 5 185 views
0 votes
1 answer

Concatenate only upper case letters?

In ms365, try: The formula in B1‡: =CONCAT(TEXTSPLIT(A1,TEXTSPLIT(A1,CHAR(ROW(65:90)),,1))) ‡ If not a ...READ MORE

Feb 16, 2023 in Others by narikkadan
• 63,600 points
716 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
• 63,600 points
979 views