Trending questions in Edureka Community

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
604 views
0 votes
0 answers
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
598 views
0 votes
1 answer

How can I automatically formulate a column while adding values ​to another? EXCEL

Use a # in your range references ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
• 38,000 points
457 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,620 points
2,930 views
0 votes
1 answer

Searching Multiple Criteria In Large Data Set to make new Data Set Excel VBA

Copy the data to an array, filter ...READ MORE

Jan 31, 2023 in Others by narikkadan
• 63,600 points
1,177 views
0 votes
1 answer

I need help connecting my python file to excel to execute the output of my program to excel

you can replace concat with append and its will work but ...READ MORE

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

PowerQuery Extract everything before alphabet from a column

Add column, custom column, with formula: = ...READ MORE

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

How To Copy/Cut Row of Data Based on TRUE/FALSE Condition [Excel VBA]

Solution Loop through the rows on the Price ...READ MORE

Feb 4, 2023 in Others by narikkadan
• 63,600 points
984 views
0 votes
0 answers

how to count the number of methods other than OPTION on AWS API Gateway with python?

I need to count the number of ...READ MORE

Feb 14, 2023 in AWS by Ashwini
• 5,430 points
576 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
566 views
0 votes
0 answers

How do I transition to DevOps Engineer?

Could you please tell me how to ...READ MORE

Feb 14, 2023 in DevOps & Agile by Edureka
• 12,690 points
570 views
0 votes
1 answer

Having trouble hiding activecell column across tabs using vba

You might keep track of the location ...READ MORE

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

OR and IF function for multiple values

Your OR functions will always return TRUE ...READ MORE

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

How to increment a column value if it repeats, otherwise reset to 1?

Use COUNTIF: =COUNTIF(A$2:A2,A2) The absolute and relative cell coordinates ...READ MORE

Feb 4, 2023 in Others by narikkadan
• 63,600 points
966 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,607 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,648 views
0 votes
1 answer

Excel Power Query Moves old Data to the right

Just empty the page and then add ...READ MORE

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

What are the prerequisites for AWS Certified DevOps Engineer Professional certification?

Could someone please let me know what ...READ MORE

Feb 15, 2023 in DevOps & Agile by Edureka
• 13,620 points
500 views
0 votes
1 answer

Excel formula in Pandas

 Use this: df['col2'] = df['col1'].shift().lt(df['col1']).astype(int) I hope this helps ...READ MORE

Jan 6, 2023 in Others by narikkadan
• 63,600 points
2,192 views
0 votes
1 answer

Inferior statement

Try this: =IF(ISBLANK(A1),"Date Missing",IF((B1-A1)<365,"Death& ...READ MORE

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

How do I copy a specific range of cells after I use AutoFilter in VBA?

Set the range of filtered data Set Rng ...READ MORE

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

Get Code Isin from Bloomberg with Excel formula

In answer to the follow-up, BQL is ...READ MORE

Oct 29, 2022 in Others by narikkadan
• 63,600 points
5,164 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
550 views
0 votes
1 answer

Python Error when I'm converting Excel to JSON

The "Birth Year" value in the p ...READ MORE

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

Application.Workbooks(V_WBNameOutPut).Activate alternative

You can capture the workbook when it's ...READ MORE

Feb 18, 2023 in Others by narikkadan
• 63,600 points
314 views
0 votes
0 answers

DevOps Engineer Roles And Responsibilities

What are the various duties of an ...READ MORE

Feb 14, 2023 in DevOps & Agile by Edureka
• 12,690 points
502 views
0 votes
1 answer

Excel file download using java - Error : File is corrupted

Try this: @GetMapping("/downloadDOA") public ...READ MORE

Dec 28, 2022 in Others by narikkadan
• 63,600 points
2,554 views
0 votes
1 answer

To Keep only 1 header while merging Multiple file

There is potential for improvement here, such ...READ MORE

Jan 31, 2023 in Others by narikkadan
• 63,600 points
1,073 views
0 votes
1 answer

How do I output the row containing the lowest value from a specific column inside a filtered dynamic array?

Instead of using 1 filter function to ...READ MORE

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

How to read A column in xlsx file with pandas?

You can view all the columns with: excel_data.head() ...READ MORE

Feb 9, 2023 in Others by narikkadan
• 63,600 points
649 views
0 votes
0 answers

What should be the career objective for DevOps Engineer?

Could someone please tell me what a ...READ MORE

Feb 14, 2023 in DevOps & Agile by Edureka
• 12,690 points
451 views
0 votes
1 answer

Macro /excel date format change

You must handle the string Date differently ...READ MORE

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

Do DevOps engineers write code?

Can anyone tell me whether coding is ...READ MORE

Feb 15, 2023 in DevOps & Agile by Edureka
• 13,620 points
395 views
0 votes
0 answers

What is the work of devops engineer?

Could you please explain the role of ...READ MORE

Feb 14, 2023 in DevOps & Agile by Edureka
• 12,690 points
422 views
0 votes
1 answer

Reshape excel table with stacked date column

I agree that using a pivot makes ...READ MORE

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

VBA Create and Rename Tables

Convert Table to Excel Table (ListObject) Option Explicit Sub ...READ MORE

Jan 24, 2023 in Others by narikkadan
• 63,600 points
1,306 views
0 votes
1 answer

Google Spreadsheet/ Excel - how to find matching values in column A, having necessary values in column M

Try this: =COUNTIF($M$2:$M$5;A2) If the product is present in ...READ MORE

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

How can I rename each column of a table?

Add Name For Each Column Sub AddNames() ...READ MORE

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

Error populating email body from word documents

There is no need to use late ...READ MORE

Jan 15, 2023 in Others by narikkadan
• 63,600 points
1,691 views
0 votes
1 answer

Sort numeric values VBA

Try: The formula in B1: =SORTBY(A1:A8,LEFT(A1:A8&"0000 ...READ MORE

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

Copy the respective values from another workbook depend on specific conditions

Try this: Sub Get_Respective_Values_Of_Last_Closing_Date() Dim wb1 ...READ MORE

Feb 6, 2023 in Others by narikkadan
• 63,600 points
733 views
0 votes
0 answers

Dump DDL for EXTERNAL FILE FORMAT - Azure SQL DW

If one had used CREATE EXTERNAL FILE FORMAT ...READ MORE

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

Conditional formatting with Index(Match), 2 conditions (vertical & horizontal)

Use FILTER to search using two or ...READ MORE

Jan 30, 2023 in Others by narikkadan
• 63,600 points
1,036 views
0 votes
1 answer

Excel to Word Macro resulting in Run-time error 462

Are you attempting this (UNTESTED)? I've commented ...READ MORE

Jan 29, 2023 in Others by narikkadan
• 63,600 points
1,074 views
0 votes
1 answer

Excel Visual Basic managing coordinate tuple type

A tuple can be saved as an ...READ MORE

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

How to rename a workbook other than using (Name) and (FileSystemObject. MoveFile)?

Use  SHFileOperation API Option Explicit Private Declare PtrSafe Function SHFileOperation ...READ MORE

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

Linux tar: gzip: stdin: unexpected end of file

The error you're getting may be because ...READ MORE

Aug 9, 2019 in Linux Administration by Kunal
55,858 views