-
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…
-
Use of If-Then-Else logic in Aperture Data Studio
Imagine you are asked to use Aperture Data Studio to generate a new field for your sales data. You have the input fields: Discount Code, Quantity and Price. The ask is to generate a new field “Offer Price” using the following logic: How can you do this in Aperture Data Studio? The answer is to build a custom transformation…
-
How is true / false field stored in Aperture?
Note that the data below is business data and not PII. Issue: When I import the CSV file created in Aperture into PowerCurve Assisted Strategy Design, it does not recognise the values in the CSV file as being text “TRUE” or “FALSE”. If I copy the values in this column and paste them into the same column as Values, then it…
-
Regular exression match not found
Hi All! I would like to create a Regular Expression match check for the whole number 3 in a string. The regex would be: [^.][3]|^3[^.] Although in the result you can see that it is not correct - the 4th line should be true as it contains 3 as a whole number. I've tested the Regex at https://regexr.com/ and it is showing…
-
2 questions on TRANSFORM
Looking for ideas from community. 1) Transform – ‘Equals’ Command I am in a workflow to check if the input file matches to data loaded in SAP Table. There are about 70 columns and I want to create new 70 check columns as follows: field1_input equals field1_Sap field2_input equals field2_Sap ... …. field70_input equals…
-
How to highlight null/empty values
When performing exploratory data analysis, or presenting data in grids in a dashboard, you may want to highlight null/empty values. Within Aperture, you can build a custom function to do this and apply it to one or more columns in your dataset. Here is an example: Go To Functions, Create new function. Create a parameter…
-
How to assign a variable value to a new column created in Transform
I am creating a new column (X) in Transform and I want to assign the value I created in the previous/same transform in another column (Y). How can I populate X with the value of Y column How can I select only specific columns to move forward in the next Transformation,. If I am having 100 columns in my current Filter…
-
IF then ELSE Logic
Can I write IF (Some Condition)THEN (Valid) Else (Invalid) Logic in Aperture? So That in the Output Result set I can view both Valid and Invalid Result set
-
Transform node in Aperture 2
Hi, I'm trying to use the Transform step in Aperture 2 and am finding that, with the limited number of columns viewable in Aperture 2 (10/20/50 rows etc) compared to the whole table being visible in Aperture 1, handling wide tables is particularly fiddly eg simply moving a column from the end of a wide table to just after…
