Errors in software suck. Who hasn’t spent time crying into their keyboard or banging their head against their screen asking the computer gods to solve their problems? Agreed—no one! As I have used Prep Builder a lot, I have developed a good sense of the common mistakes people make with the tool. This chapter will address the following trouble spots and pose some potential solutions:
Parameter errors
Blank Profile and Data panes
Errors within a Calculated Field
Parameter Errors
You may often see an error message including the word parameters. For example, the error message in Figure 41-1 reads Function 'DATEADD' can't accept parameters: (string, integer, string).
In this case, parameters are the data fields, numbers, and strings you are entering into your calculations. The calculation expects a certain data type in these fields and can’t accept a different one. In this specific case, my colleague was using a date in a string field. The DATEADD() function specifically needs a valid date for the calculation to increment.
Figure 41-1. A common error message regarding parameters in Prep
Be sure to check the data types that you are using in the calculation against what the syntax expects. Remember, you can see an example of each function’s syntax to the right of the Reference list in the Edit Field dialog.
Blank Profile Panes or Data ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
