Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Unique tool with Dynamic or Unknown Options

vepp
8 - Asteroid

Hello All,

 

Does anyone has Macro or Idea to select "Dynamic or Unknown Fields" in Unique tool?

My required is to pass any  number  of fields and get unique records. Every time my input fields would changes

 

Please help.

 

Regards,

Vp

11 REPLIES 11
DataDynamite
7 - Meteor

I'm validating a large migration of data from SQL Server to SnowFlake and of course I want this validation to be as automated as possible. Most of what I wanted to achieve is done but I thought if could just do this one more thing I would be really satisfied with the process.

 

Within a batch macro I query a table from both databases, remove duplicate records and then count records.  I also union these two datasets together, remove duplicates and count records.  The idea being that I have an exact match if all three counts are the same.   I'm feeding this batch a large number of tables to check (all of them different).   None of usual tools for removing duplicates (Unique, Sum , Tile, multi-field formula) could handle the dynamic nature of what I needed to accomplish.

 

This post helped me achieve that. THANKS!!!  ~DD

 

 

DataDynamite
7 - Meteor

Hi Dan,

 

I ran into a situation when the concept wasn't giving me the results I expected.

 

I isolated a sample to test with, I would expect it to consider these records to all be unique but because there are (multiple?) duplicate name value pairs the workflow pattern determines a few of the records to be duplicates.

 

CLIENTIDVERSIONGL_ACCOUNTBUSUNITVALUELASTUPDATED
PlanOpex475Budget 2023701658907.80686852/17/2023
PlanOpex475Budget 2023701707907.80686852/17/2023
PlanOpex475Budget 2023701709907.80686852/17/2023
PlanOpex475Forecast 2023 0+12701658907.80686852/17/2023
PlanOpex475Forecast 2023 0+12701707907.8068685 2/17/2023
PlanOpex475Forecast 2023 0+12701709907.80686852/17/2023

 

I think perhaps we need to add a summarize tool after the transpose to concatenate all of the values together for a given record id.  

 

DataDynamite_0-1683129794274.png

What do you think?

 

~Data Dynamite

Labels
Top Solution Authors