Which script line should the data architect use?

Refer to the exhibit

A large transport company (Company A) acquires a smaller rival (Company B).

Company A has been using Qlik Sense tor 6 years to track revenue per ship journey. Ship journeys with no revenue (such as journeys to shipyards for repair) always show revenue of $0.

Company A wants to combine its data set with the data set of the acquired Company B.

Company B’s ship journey data shows $0 revenue in one of the following ways:

• A NULL value

• A value with one or more blank spaces (ASCII char code 32)

The data architect wants to conform the Company B data to the Company A standard, specifically regarding the use of an explicit $0 for journeys without revenue.

Which script line should the data architect use?

A)

B)

C)

D)

A . Option A
B . Option B
C . Option C
D . Option D

View Answer

Answer: A

Explanation:

In this scenario, the data architect needs to conform the revenue data from Company B to match the data standard of Company A, where $0 is explicitly used to represent journeys without revenue.

Explanation of the Correct Script:

Option A: money(replace(Revenue, chr(32), 0)) AS [Revenue Conformed]

replace(Revenue, chr(32), 0): This part of the expression replaces any spaces (ASCII character code 32) in the Revenue field with 0.

money(…): This function formats the resulting value as currency. Since Company B may have either null values or spaces where 0 should be, this script ensures that any blanks are replaced with 0 and then formatted as currency.

Why Option A is Correct:

Handling Spaces: The replace() function is effective in replacing spaces with 0, conforming to Company A’s standard of using $0 for non-revenue journeys.

Handling NULL Values: The money() function is used to ensure the final output is formatted as currency. However, it’s important to note that NULL values are not directly handled by the replace() function, which is why it is applied before money() to deal with spaces.