Webclass 146: Duplicates – a data analytics skill that covers many issues in Finance, P2P, O2C and HR

Q1. Why might it be easier to do duplicates in ACL?

Because you don't have to write any code

Correct Incorrect Correct answer

Because it is quicker to run in ACL

Correct Incorrect Correct answer

Q2. How can we generate the code in ACL for our duplicates test?

Copy the code from the log

Correct Incorrect Correct answer

By writing a python program

Correct Incorrect Correct answer

Q3. What is an advantage of using SQL over ACL for split POs analysis?

In SQL, we can have the query that checks if the dates are within a certain number of days of each other, whereas, in ACL we cannot

Correct Incorrect Correct answer

In SQL we can run the duplicates test using buttons

Correct Incorrect Correct answer

Q4. If you don’t need to compare dates when doing the join in SQL, which other clause could we use for testing for duplicates?

HAVING COUNT(*)>1

Correct Incorrect Correct answer

WHERE EXISTS

Correct Incorrect Correct answer

Q5. Why might we not want to include records for which the vendor is not mentioned?

Because these might just be stock transfer orders

Correct Incorrect Correct answer

Because there is less risk if the vendor is not mentioned

Correct Incorrect Correct answer

Q6. In SQL, to ignore records where the material number is not filled in, would it be better to say MATNR<>”, ISNULL(MATNR,”)<>” OR LEN(MATNR)<>0?

LEN(MATNR)0 because this works in case the field is NULL (for example after a FULL outer join) or blank (for example because it is not filled in)

Correct Incorrect Correct answer

ISNULL(MATNR,'') '' because ISNULL and blank mean the same thing

Correct Incorrect Correct answer

Q7. Qlik code is more similar to ACL code or SQL code

SQL code

Correct Incorrect Correct answer

ACL code

Correct Incorrect Correct answer

Q8. Python script is more similar to ACL code or SQL code

Neither

Correct Incorrect Correct answer

SQL code

Correct Incorrect Correct answer

Q9. Which term do we use for join in python?

Merge

Correct Incorrect Correct answer

JOIN

Correct Incorrect Correct answer

Q10. In python, which key word gives us the number of records per key that is included in the groupby?

size()

Correct Incorrect Correct answer

reset_index()

Correct Incorrect Correct answer

Q11. Why might we want to make a generic routine for duplicates?

So that we can use similar logic across all business processes and data types, making the code maintenance more efficient

Correct Incorrect Correct answer

So that the code will run quicker

Correct Incorrect Correct answer

Q12. What would be a typical risk area relating to the presence of duplicate customers?

New copies of the customer are created in order to increase the total ageing balance for the customer

Correct Incorrect Correct answer

Over-reporting of sales figures

Correct Incorrect Correct answer

Q13. Which python library did we use in order to be able to check if a company name is a proper noun or not?

NLTK

Correct Incorrect Correct answer

Spacy

Correct Incorrect Correct answer

Q14. In the python program using NLTK, is_name() function, do we select True only if all words in the name are a proper noun or if any one of the words are a proper noun?

Any one of the words

Correct Incorrect Correct answer

All of the words

Correct Incorrect Correct answer

Q15. Does the python program use NLTK to group together the customer names?

No, it only uses NLTK to check for proper nouns

Correct Incorrect Correct answer

Yes

Correct Incorrect Correct answer

Q16. How does the python program group together similar customer names?

By creating the group name, which is the customer name that has had all special characters or specific words removed

Correct Incorrect Correct answer

By using NLTK to convert the name into a proper noun

Correct Incorrect Correct answer

Q17. How might you improve the python program?

Include other ways for doing fuzzy matching, such as making the words in the same alphabetical order within the name, removing stop words (in,on, etc), adding other words to ignore to the NameList

Correct Incorrect Correct answer

By using a shorter list of customers and reviewing them in batches

Correct Incorrect Correct answer

WC146 – Duplicates – a data analytics skill that covers many issues in Finance, P2P, O2C and HR

Quizzes

Participants 11

Webclass 146: Duplicates – a data analytics skill that covers many issues in Finance, P2P, O2C and HR

admin June 9, 2026

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

9. Question

10. Question

11. Question

12. Question

13. Question

14. Question

15. Question

16. Question

17. Question