-
Flattening out / Pivoting / Transforming results
Hi, I'm having an issue flattening out results. Essentially, I have multiple rows for the same customer because they have different PII's. Is there any way of transforming / pivoting / flattening out the results to have one row for each customer? I have left a screenshot of mock-up data below to help people understand. I…
-
Group Step > Being able to select and right click view multiple rows in groups
What problem are you facing? When the Group step is used, we can only view rows in group on one value. What impact does this problem have on you/your business? Feedback received of this not being user friendly and having to exit the screen to be able to get to the multiple filtered values. Do you have any existing…
-
Group in Validate step
Is it possible to Group in Validate Step. My Goal is to get the Data Along with the Stat example I want to see how many contacts are active , inactive and Passive along with that when I click Active stats it shows me the data like the way we can do in interactive snapshot.
-
Counting repeated values in a Column
Good afternoon, Looking for a function that counts the number of times a value appears in a colunm and returns the number of that particular repetion as a number. see example below Many thanks in adavance fo the support. Best regards, Marco
-
Pivot grouping issue?
Hi All, I have an issue with the pivot and I'm not sure how to solve this or what function to use to get a similar arrangement! I would like to arrange my dataset so that I see all vendors in one column grouped and all the other data columns arranged in further columns: Normally the column selected as the "pivot ID" should…
-
The Group in the pivot seems not working perfectly
The group in the pivot is not working perfectly and it is not arranging the values into columns as it should. We noticed that it is when we also have a sort before the pivot step. We had the same issue in version 2.4 and it still remain in version 2.8.8. Has anyone else faced this issue? Have you found any work-around?
-
Word Frequency
Every now and then a scenario crops up where it'd handy to know how often a given word occurs within a given dataset. For example you're profiling a reasonably standardised list of values (e.g. job titles) and you want to identify unusually common terms (like 'manager' 'executive' etc) or infrequent ones (like 'test123').…
-
Group step in Workflow throws java.lang.IllegalArgumentException: Invalid handle
Hello there, I have a workflow in Experian's Aperture Data Studio (version 2.5.11.115) which unions 24 inputs From this union, I then have a group step which allows me to see what the validation results are for each category When I use aggregates, there is no problem but when I group and aggregate together, I get this…
-
Exact Match with the Group Step
The Group step can be used as an easy way to identify and de-duplicate data that matches exactly. Let's take a look at an example, where you have a list of vehicles that may be duplicated. When you connect this dataset to a group step in a workflow, the results provide a count of each vehicle along with the unique list of…
-
Ensuring you always return the same duplicate ID with Find Duplicates
Find Duplicates returns consistent Cluster ID after each run. Consistency here applies to the sequence order of the input file. So if the same file is submitted to Find Duplicates, in the same order, then the Cluster ID will be the same on each run. In some cases you may not be able to guarantee the order of the records…
