nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Data Prep Steps on Entire Dataset

Branden Pavol

I'm using a Group step in Data Prep and it's not giving me all options. It's only giving me some of them and not all of them. In my screenshots, you will see I'm grouping every table with the name "argus" in it. In the data prep step, it's showing only two are available based on the profiling. When I go to the actual results, there are more. There should be an option to profile based on the sample size or the entire dataset. Otherwise, I'm forced to do a large case statement.

Find more posts tagged with

Under Review

Data Preparation and Flows

Status: Under Review

Comments

Rajakumar Burra

Year back, it used to work. I have few datasets defined with those options.

Later it is regressed, and I have filed SR as well.

Luis E. Rivas -Oracle

Hi, as you have already noted, the values shown in the Grouping dialog are based on representative sampling and in some cases, low frequency values in columns will be missed. We are exploring both options to increase the sampling for profiling or allowing full sampling, but we are also exploring options of the dialogs such as grouping and others that depend on the distinct values, query their own values instead of using the sampling from profile. This will allow the random sampling to continue and for the dialogs to get their own values. I'll check to see where we are and report back soon.