Trending questions in Edureka Community

0 votes
0 answers

How to convert xml to csv file

The data in xml file is someting ...READ MORE

Jan 29, 2023 in Python by Wu

edited Mar 4, 2025 516 views
0 votes
1 answer

HTML and CSS: What do the <ul> and <li> tags stand for?

The term ul stands for unordered list. ...READ MORE

Aug 4, 2022 in CSS by Tanishqa
• 1,370 points
8,187 views
0 votes
1 answer

Excel VBA- Creation of a New datablock with criteria

To insert the dropdown, you can go ...READ MORE

Jan 12, 2023 in Others by narikkadan
• 86,360 points
1,231 views
0 votes
2 answers

Render HTML in React Native

React Native does not provide any specific ...READ MORE

Apr 1, 2023 in HTML by DSKView
• 180 points
2,921 views
0 votes
1 answer

How to convert data from txt files to Excel files using python

Hi , there are few steps to ...READ MORE

Feb 16, 2022 in Others by Edureka
• 13,690 points
15,476 views
0 votes
1 answer

Is there a way to quickly check what attribute the data is in a cell in a spreadsheet?

Excel will automatically make assumptions about the ...READ MORE

Jan 8, 2023 in Others by narikkadan
• 86,360 points
1,394 views
0 votes
0 answers

Most relevant learnings to radio communications speciality

I come from the military communication field ...READ MORE

Jan 21, 2023 in Career Counselling by anonymous

edited Mar 4, 2025 847 views
0 votes
1 answer

DB2 SQL error sqlcode=-104 sqlstate=42601

You missed the from clause: SELECT * from TCCAWZTXD.TCC_COIL_DEMODATA WHERE ...READ MORE

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

Excel Formula multiple Index Match and Average the result

If the conditions are separate and unrelated, ...READ MORE

Oct 31, 2022 in Others by narikkadan
• 86,360 points
4,373 views
0 votes
0 answers

What is "main" branch in context of Azure DevOps pipeline caching?

I'm attempting to employ the Azure DevOps ...READ MORE

Jan 3, 2023 in DevOps on Cloud by Damonlang
• 1,230 points
1,623 views
0 votes
0 answers

the best IT speciality for a 40 years old discharged military officer to learn

My career in the armed comes to ...READ MORE

Jan 21, 2023 in Ask us Anything! by anonymous

edited Mar 4, 2025 840 views
0 votes
1 answer

Excel:- Comparing 2 columns and then copying value in 3rd column

There is an excel if() function for ...READ MORE

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

How to merge two Tables and Add the amount at the same time?

Use SUMPRODUCT like this: =SUMPRODUCT(($A$2:$A$5=A10)*$B$2:$B$5)+ ...READ MORE

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

How do I install Java on Mac OSX allowing version switching?

With Homebrew and Jenv: Assumption: You have a ...READ MORE

Jan 3, 2023 in DevOps on Cloud by David
• 220 points
1,597 views
0 votes
1 answer

Textjoin with adjacent headers and rows with a twist

Try the following formula- =TEXTJOIN(" ",1,FILTER($A$1:$C$1,A2:C2<>"")&":"&FILTER(A2:C2,A2:C2<>"")) To make it ...READ MORE

Jan 10, 2023 in Others by narikkadan
• 86,360 points
1,293 views
0 votes
0 answers

Referencing an element while using count in terraform resource and handling the case when count is 0

I have an AWS WAFv2 Web ACL ...READ MORE

Dec 20, 2022 in AWS by Tejashwini
• 5,380 points
2,222 views
0 votes
0 answers

the cloud platform which are not used for devops implementation?

Among which if the following cloud providers ...READ MORE

Dec 22, 2022 in DevOps on Cloud by Edureka
• 13,730 points
2,134 views
0 votes
1 answer

Adding column to Excel using Apache POI

The quickest way to add a column ...READ MORE

Nov 19, 2022 in Others by narikkadan
• 86,360 points
3,539 views
0 votes
1 answer

Numbering/sequencing sets of same column values

You can accomplish this with countif and a sliding ...READ MORE

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

Why is my code grabbing row number from the wrong Excel sheet?

I changed this: iTotalRows = source.Worksheets("Export").Range("B1:B" & Cells(Rows.Count, ...READ MORE

Jan 10, 2023 in Others by narikkadan
• 86,360 points
1,280 views
0 votes
1 answer

How do I merge multiple excel files to a single excel file

You copy a worksheet from before each ...READ MORE

Dec 24, 2022 in Others by narikkadan
• 86,360 points
2,009 views
0 votes
0 answers

Azure devops pipeline variable for a task step name

Is a variable available for the name of an Azure devops pipeline task step, as highlighted below? image from the pipeline I went over the predefined variables at https://learn.microsoft.com/en-us/azure/devops/pipelines/build/variables?view=azure-devops&tabs=classic  However, ...READ MORE

Jan 5, 2023 in DevOps on Cloud by Damonlang
• 1,230 points
1,507 views
0 votes
1 answer

Date format conversion in Excel

You appear to be misunderstanding the point: ...READ MORE

Jan 8, 2023 in Others by narikkadan
• 86,360 points
1,347 views
0 votes
0 answers

Get the name of a dynamo table created with AWS CDK

Using the example from here. I can create ...READ MORE

Jan 3, 2023 in AWS by Tejashwini
• 5,380 points
1,527 views
0 votes
1 answer

Excel: How to analyze data in a table that contains multivalue cells

 The below formula will create a unique ...READ MORE

Jan 10, 2023 in Others by narikkadan
• 86,360 points
1,261 views
+1 vote
0 answers

How to keep Docker container running after starting services?

Although I've read many instructions that appear ...READ MORE

Dec 13, 2022 in Docker by Edureka
• 13,730 points
2,441 views
0 votes
1 answer

Dynamic chart range using INDIRECT: That function is not valid (despite range highlighted)

Similar to Sean's fantastic response, mine also ...READ MORE

Dec 27, 2022 in Others by narikkadan
• 86,360 points
1,859 views
0 votes
0 answers

How to get the current London time and date using javascript

Using the code below, I attempted to& ...READ MORE

Dec 7, 2022 in Java by Nicholas
• 7,760 points
2,623 views
0 votes
1 answer

How to get the user's country calling code in iOS?

Import Statement : #import<CoreTelephony/CTCarrier.h> #import <CoreTelephony/CTTelephonyNetworkInfo.h> you can get country ...READ MORE

Dec 15, 2022 in Mobile Development by gaurav
• 24,860 points
2,846 views
0 votes
1 answer

how devops works with aws?

The two most potent technologies—AWS and DevOps—can ...READ MORE

Jan 3, 2023 in DevOps on Cloud by Edureka
• 12,730 points
1,537 views
0 votes
1 answer

How can I measure time more precisely in VBA?

At the top of the script you ...READ MORE

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

Why is `(True, True, True) == True, True, True` not True in Python?

Operator precedence. You're actually checking equality between (True, ...READ MORE

Jan 4, 2023 in Python by Elton
• 400 points
1,485 views
0 votes
1 answer

Mat-icon doesn't export in excel sheet?

Icons have their own coding you can ...READ MORE

Dec 15, 2022 in Others by narikkadan
• 86,360 points
2,336 views
0 votes
1 answer

Transform Excel table columns (not all) into rows - long to wide transformation

In PQ, highlight the Group column and ...READ MORE

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

How to make lambda function working on excel365?

Use this: =BYROW(SEQUENCE(5),LAMBDA(b,TEXTJOIN(",",,SEQUENCE(1,5,b)))) The second sequence is changed from ...READ MORE

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

How to automate split by delimiter in Excel (equivalent of =SPLIT in gSheets)

Multiple ways, one is to use FILTERXML():   Formula in B2: =TRANSPOSE(FILTERXML("<t><s>"&SUBSTITUTE(A2," ...READ MORE

Dec 29, 2022 in Others by narikkadan
• 86,360 points
1,745 views
0 votes
1 answer

Can you use aws-sdk/util-dynamodb unmarshall in Reactjs?

Yes, you can use the unmarshall method ...READ MORE

Jan 4, 2023 in AWS by Ashwini
• 5,430 points
1,471 views
0 votes
1 answer

how to verify jwt token in nodejs / never expire?

You can achieve this by using the ...READ MORE

Jun 17, 2022 in Node-js by Neha
• 9,020 points
10,136 views
0 votes
1 answer

MS Excel TRUE/FALSE Formula Not Returning Expected Result

The reason for this is that the 'words' ...READ MORE

Nov 8, 2022 in Others by gaurav
• 24,860 points
3,920 views
0 votes
1 answer

How to get password of the Amazon aws rds user?

Follow these procedures to update the master ...READ MORE

Mar 9, 2022 in Others by gaurav
• 24,860 points

edited Jun 20, 2023 by Khan Sarfaraz 14,462 views
0 votes
0 answers

Can we automate React app using selenium?

Can we automate React app using selenium? READ MORE

Jan 19, 2023 in Selenium by Sukanya

edited Mar 4, 2025 825 views
0 votes
0 answers

Can't play video on iOS in Safari: NotAllowedError

When I click a play button on ...READ MORE

Nov 8, 2022 in Mobile Development by gaurav
• 24,860 points
3,153 views
0 votes
1 answer

Error saying " Invalid operation uninstall" on sudo apt uninstall apache2

sudo apt remove apache2 READ MORE

Mar 29, 2024 in Linux Administration by Anonymous

edited Mar 5, 2025 20,442 views
0 votes
1 answer

How to turn a string formula into a "real" formula?

Evaluate might suit: Function Eval(Ref As String) ...READ MORE

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

How to exclude weekend (Sunday only) to DATEDIFF in Tableau?

To exclude Sundays from the DATEDIFF calculation ...READ MORE

Jul 3, 2023 in Tableau by anonymous
• 1,420 points
3,428 views
0 votes
1 answer

How to validate values entered in a multiline Excel cell?

Try: The formula in B1: =AND(BYROW(TEXTSPLIT(A1," "," ",1),LAMBDA(x,SUM((LEN(x)={3,7,4,4,5})ISNUMBER(-x)(MID(TAKE(x,-1),3,1)="."))))) Or, write a ...READ MORE

Jan 13, 2023 in Others by narikkadan
• 86,360 points
1,052 views
0 votes
0 answers

Connect to RDS through VPC Peering

I'm attempting to establish a VPC Peering ...READ MORE

Jan 18, 2023 in AWS by Tejashwini
• 5,380 points

edited Mar 4, 2025 850 views
0 votes
1 answer

Hosting Microsoft Edge via WebView2Loader.dll with Excel VBA

Here's an API to communicate with Chromium ...READ MORE

Sep 29, 2022 in Others by narikkadan
• 86,360 points
5,665 views
0 votes
1 answer

Copy last 3 rows, excluding the rows for which there is a "0" in column "C"

The copy inside the loop is overwriting ...READ MORE

Jan 10, 2023 in Others by narikkadan
• 86,360 points
1,164 views
0 votes
0 answers

Origin of the C# language name

Programmer in C and C++, currently attempting ...READ MORE

Sep 20, 2022 in C# by Edureka
• 13,730 points
1,417 views