Use an unsupported aggregation.. s3. Use an unsupported aggregation.

 
s3Use an unsupported aggregation. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation

If it’s not supported, you may need to upgrade your. Is there a way to do it in a single query like in. additional request properties set programmatically. what I understood from my network colleague concept of LACP. The limitation on mixing data often occurs with non-additive aggregates such as MEDIAN or COUNTD. When I am joining the two data sources I wanted to use "F Name" column with "Name" column. It is now possible in Amazon QuickSight. UNSUPPORTED_TABLE_ARGUMENTWindowed Aggregations. Where the description. Golang mongodb Aggregation too many values in. Loading. A value greater than 0 treats a grade item's grades as extra credit during aggregation. Fleet for one year. Depending on the type of data item, applies. B. image 959×146 4. In the LACP section, click the +NEW symbol to create a new LAG. On this page you'll find information regarding errors that you might encounter when using our aggregation, enrichment, and payment initiation API, and how to solve them. I'll play around with it, see if I can make it work that way. It can be misunderstood, but, when using a data blend correctly, it is an efficient way to merge data sources in Tableau. ×Sorry to interrupt. Click on the different cookie categories to find out more about each category and to change the default settings. elastic. Hi. Kindly see the screenshot as below:- data from the second source comes over as an aggregate - look into what the aggregation is on and how does that relate to what you have in the primary data base . JimI have linked 2 sources using 3 dimensions. We have a two data sources in Excel. . (So does the original [Pivot Field Names] field. But is there any other way around? Please help me in this regard, thanks, KalyanLocal Cumulative Computation makes the Process more Efficient. Click on the different cookie categories to find out more about each category and to change the default settings. bucket. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. addShardToZone () applyOps. In this guide, we are going to walk you through the programming model and the APIs. We are blending two data sources. Got same expected results in both py2 and. Even if I don't join the 2 data sources and just blend them by "Region" and "Store Name", I still get "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" on dragging Total Utilized Money field into the view. We use three kinds of cookies on our websites: required, functional, and advertising. There are two types of calculated fields: on a data set level and on on analysis level. Unsupported aggregations in data blending Hello, I have a distributor dataset with product ships and returns (one report covering six months), and a retailer dataset with product retail sales and stock (covering the same six months but composed of. Click on the different cookie categories to find out more about each category and. I am trying to put my LOD calculation (below) on the rows shelf but encountering "cannot blend the secondary data source because one or more fields use an unsupported aggregation" {include [DATE MONTH],[STATE]: sum([Quantity. I was now trying to use both calculations you did on a different sheet through data blending. A value greater than 0 treats a grade item's grades as extra credit during aggregation. Cannot blend the secondary data source because one or more fields use an unsupported aggregation issue. Cannot blend the secondary data source because one or more fields use. The driver does not provide methods for all aggregation pipeline operators in the Query API. This should explain why when you are using the SUM aggregation it works. Parameters: funcfunction, str, list, dict or None. We are blending two data sources. “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. Add a comment. You can choose whether functional and advertising cookies apply. step 1 : I do teaming for interface A & B, enable LACP on virtual teaming interface. 7. I get the the following error: unsupported aggregate action Digging through the source code I found there is no handler for collect. Aggregate Functions #. You can choose whether functional and advertising cookies apply. 2. category. First, let’s start with a simple example of a Structured Streaming query - a streaming word count. For example am having column called "Name" in my first data source, in second data sources am having column called "F Name". I did that in your example too. (This is more of a workaround) Use a viz in tooltip to show the members of the dimension instead, coming from a different worksheet. Default aggregation for Exclude LOD is ATTR. Use expressions to define the values that are sent from Tableau to the analytics model. ×Sorry to interrupt. Thanks, PaoloThis didn't work alas, "cannot blend secondary data source because one or more fields use an unsupported aggregation" I am using a filter from a different datasource to filter by region . You can choose whether functional and advertising cookies apply. 0. When I calculate the average of a measure and use the filter, it works perfectly fine. ×Sorry to interrupt. We don't get row-level data from secondary. Find centralized, trusted content and collaborate around the technologies you use most. I've tried that in the past, and I was always blocked by the unsupported aggregation message. Unsupported aggregate subquery with non-equality correlated predicates. See the Description column for details. You can use the variable REMOVE in aggregation expressions to conditionally suppress a field. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. The primary one is called Dim_Service_Status. IF ISNULL(D1) THEN D2. Let me look into the “Scaffold” option. Region, sum (Orders. The tff. You cannot convert a string value of a float or decimal or non-base 10 number (e. For example, there are aggregates to compute the count, sum, avg (average), max (maximum) and min (minimum) over a set. Usage In SortIf you have selected the modeling properties Activate Data and Write Change Log, you can choose from the following aggregation types: Summation, Maximum, Minimum and Overwrite. Basically, I am using filters with only one filter (thus only one bucket) so that we can have a max bucket pipeline aggregation (which only supports multi-bucket) and then the pipeline aggregation name can simply be the detector field name (metric1_value and matric2_value in this specific case):This time we're going to do what would have been a MongoDB aggregation pipeline, but this time using LINQ. Click on the different cookie categories to find out more about each category and to change the default settings. _types. I'm noticing you are using the Date field from the secondary data source you are working with. The strange thing is running the query (the one that the Java API gives on a to string) through the REST endpoint works fine. For example I might need to add a dimension to the view to get my non-additive aggregate or LOD to work and then I get a lot of extra marks, then I could use something like IF FIRST()=0 THEN SUM() END to get back to a single mark for. Step 2: Setting the Default Aggregation for a Measure in Tableau. Some functions, such as , are available only when you click the summarize button on the report object toolbar. Documents flowing through the aggregation pipeline are classified. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The problem is when I try to calculate the median of that same measure. It shows the next message: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". I have an LOD expression that works fine when the data source is the primary, but when I switch it to a secondary data source and then add the LOD expression to a view I get the annoying, "Unsupported aggregation" issue. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Name, Company. They both share a common field (State), and that is what I'm filtering on. Hi everyone, I'm trying to blend two data sources on a single. ORDER BY clause) but you should expect the order not to match. CompanyID =. Unsupported aggregation stages. {FIXED [Machine Nr] : COUNT ( [Machine Nr] )} / {FIXED [Machine Nr] : COUNT ( [Machine Nr] )} This works fine when there is no secondary data source but when I blend with a secondary data source it grays out my sheet i. When there is unsupported aggregated measure using WINDOWS Functions, COUNTD,LODs etc. If you perform an aggregation on a baseline column through a SQL request, the Analytics Server calculates the aggregation grain at the level based on the following rules: If there is no GROUP BY clause specified, the level of aggregation is grouped by all of the nonaggregate columns in the SELECT list. I have 2 duplicate data sources that I am blending together (they are duplicate because I want to filter the same data source 2 different ways but show it in. t Link Aggregation. ) to such a degree that you need table calcs to re-aggregate to get to the desired granularity of the display. One is to create a pass-through SQL table. . In this example, Geog_School is used. Had a chance to test it, and it seems to work in both py2 and py3. All the data is in the secondary/blended data source. addShard () addShardToZone. ) I need to revisit my understanding of the limitations here! I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Provide details and share your research! But avoid. Change the C# code in the Program. For example, see Text Search in the Aggregation Pipeline. Discussions; Teams. NoDays >> * <<root. In general, these expressions take an. An expression has a finer level of detail than the view when it references a superset of the dimensions in the view. federated_computation(lambda: 'Hello, World!') ()IF user chooses month X and parameters/filters like gender/age/etc, THEN count all distinct users from data set #2 where the date of data set #2 is from 2017-08-01 through today's date. Example(cannot blend the secondary data source because one or more fields use an unsupported aggregation) If i select without distinct, it's ok (but not what I want. Loading. I'm using a cube data source as my primary and am attempting to blend with an Excel sheet. If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the. 3 and I have created aggregates AGG for fields from data extract and excel file. if a host has 2 interfaces ports ( A & B ) connected to switch A on port 1 & port 2. This method has existed since the introduction of SQL tables in CA 11. We use three kinds of cookies on our websites: required, functional, and advertising. Hello Jim, Thank You for your reply. Resolution. An aggregate function computes a single result from multiple input rows. Another table is a a table that contains key fields such as date, region, location and hardware id (dimension). I have 2 filters (BU ISNull and CORPID) applied from secondary data source. 0. CSS ErrorUnsupported Commands in Serverless Instances. CSS ErrorThe problem is that calculation on CDS views by default are done at records level and aggregated, hence my idea was to use the @DefaultAggregation: #FORMULA annotation to get the desire result. Blending data - Unsupported aggregation MIN MAX. (Ditto the FIXED countD. The first part is the source data. Instead of blending multiple data sources, create one data source that joins all of the data using either physical or logical joins. I've read through the various posts on here, plus the general troubleshooting posts on the Tableau page on blending data, but can't find a solution. "cannot blend the secondary data source because one or more fields use an unsupported aggregation" Attached is the workbook that could provide more clarity on my question. ×Sorry to interrupt. Use a derived table to nest aggregations or double aggregate. When LSOAs are aggregated up to MSOAs i need the percentage to be calculated from the LSOA dataCount Distinct in Secondary Data Source - "cannot blend secondary data source because one or more fields use an unsupported aggregation" Hi! I'm trying to blend 2 data sources. cannot blend secondary data source because one or more fields use an unsupported aggregation beacuse of LOD. If a function, must either work when passed a DataFrame or when passed to DataFrame. And, if you have issues with dates missing in one vs the other, you could use a date scaffold: Creating a Date Scaffold in Tableau - The Flerlage Twins: Analytics, Data Visualization, and Tableau “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. When using the function, the data types and order of the expressions must match that of the input arguments. It doesn’t understand the use of LIMIT 1: delete it and wrap your sub queries in an aggregate function - MIN() looks like a good choice - adding the obligatory GROUP BY SELECT (SELECT MIN(b. Then the pivot rearranges it, creating columns for the in values from the name column, and using the aggregate ( max (data)) for the value in that column, which should give the desired results. This happens only when the data sources are impala. I did that in your example too. When trying to use COUNTD () it gives this error: cannot blend secondary data source because one or more fields use an unsupported aggregation when. This ordering is unspecified by default, but can be controlled by writing an ORDER BY clause within the aggregate call, as shown in Section 4. SimpleAggregateFunction(name, typesofarguments…) data type stores current value of the aggregate function, and does not store its full state as AggregateFunction does. You can choose whether functional and advertising cookies apply. (You need to get individual row access to evaluate DISTINCT functionality. Creating the flags in your query is best done with CTEs using a separate section for each of your module flags so you don’t. You can use aggregations in the analysis level calculated field. If if this is the case, you could try creating a calculation for. It's possible you're trying to use an unsupported aggregation with the blend. Click From Other Sources, and then click From Data Connection Wizard. Cannot blend the secondary data source because one or more fields use an unsupported aggregation . Right-click the field you are aggregating and select Properties. Click on the different cookie categories to find out more about each category and. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. Sometimes , it's automatically working but sometimes it says 'Unsupported Aggregation' . The current aggregation appears as part of the measure's name in the view. ×Expression Operators. If the user select May 2018. Build the future of fintech in Latin America by connecting your. ×Sorry to interrupt. 5. Loading. Aggregate functions in PostgreSQL are defined in terms of state values and state transition functions. Let's say for example that you wanted. The driver does not provide methods for all aggregation pipeline operators in the Query API. The issue was that the bucket sensor that I had previously defined in my telegraf. I've created the first chart with no problem, but I. The steps are. InternalFilter as an unsupported. We use three kinds of cookies on our websites: required, functional, and advertising. The issue is the data for the week numbers and RORs is not breaking down to the individual days/weeks/lines. Ask Question Asked 3. Log “Unsupported aggregation type [{}]” class name is Pivot. Can anybody please help me with a solution. it's not possible to. When you try to do that, Tableau generates the "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" error, turns the offending pill red, and grays out the view. I am trying to create a waffle chart. person = a. Computing or filtering based on an aggregated value is not supported. In our example, we could write the original as: select Company. You should wait for the next scheduled. I use {Fixed [Owning Location Code], [Location Code], [Vehicle Group], month([MB Date]) :Avg([Avg Fleet])} to get the Avg. This is a new complexity in Tableau v8: In v7 and earlier, to blend we had to have the linked dimensions in the view, i. Jim. IN/EXISTS predicate subqueries can only be used in filters, joins, aggregations, window functions, projections, and UPDATE/MERGE/DELETE commands <treeNode>. Please excuse my lack of language skills - but the field that is causing the problem is the Max() calculation that is a record by record comparison across a data file - Are you using a live data source on that data set? If you can't get around using the function you could extract that data first . Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. I know that count distinct can not be used in the data blending. Step 5: Change “Association With” from “InfoObject” to “Nothing”. In aggregation, following a stage that outputs a field with the text score value, you can specify a query condition or operate on the field in subsequent stages. Use aggregation instead. Real-time aggregates automatically add the most recent data when you query your continuous aggregate. Use SIZE (): This is similar to #1, but provides a better visual and is more flexible with other analyses. Learn more about Collectives Teams. You can choose whether functional and advertising cookies apply. Unsupported Aggregation, Quick Table Calc Sets, and Filters from Secondary Data blends?. i want to create a segmentation for my customer based on three things: Days since last purchase (This comes from a query that has user_id, min(day_since_last_purchase) from X) – i need to do the min because there are multiple profiles per user and i want to know the min per user regardless the profile % change in. ERROR 2381: Cannot create a sequence with RESTART. But a filter or range gives org. With LAC-A functions, you can specify at what level to group the computation. In find, you cannot specify a query condition on the text score. Cannot blend the secondary data source because one or more fields use. Select the number of ports per host desired. The chart should display: countd. You can choose whether functional and advertising cookies apply. This aggregation provides a way to stream all buckets of a specific aggregation, similar to what scroll does for documents. Isilon - Link Aggregation LACP. So in my case where CKF1 = RKF1 - RKF2, I will need to store this result in the database as a key figure. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. But considering using it with Materialized View, the doc says SimpleAggregateFunction(name, types_of_arguments…) data type stores the current value of the aggregate function, and does not store its full state as AggregateFunction dose, which means. The expression of the column which has an unsupported. If you have not selected any modeling properties, you are not offered any aggregation types at all. Learn more about Collectives. Share. tff. Go to a new worksheet. Send us feedback | Privacy. Ditto: { FIXED [Patient ID] : COUNTD([Patient ID]) } Yet there it is in your workbook, very happy and functional. Aggregate Functions #. step 2 : network person on. And put both views on a dashboard. The number is a factor by which the grade value will be multiplied before it is added to the sum of all grades, but the item itself will not. You can choose whether functional and advertising cookies. (Ditto the FIXED countD. An old, now unsupported aggregation strategy provided here only for backward compatibility with old activities. Inn order to get the top 10 results you would need to use the terms aggregation with a filters sub-aggregation. I've tried using COUNTD() ID First Last 1 Jim Carrey 1 Jim Carrey 2 Liam Neeson 3 Wynona Ryder COUNT([ID]) = 4 COUNTD([ID]) results in. Click on the different cookie categories to find out more about each category and to change the default settings. Unsupported aggregate subquery with non-equality correlated predicates. To indicate a cursor with the default batch size, specify cursor: {}. The workaround for this is that if you have to use one of the non-additive. The following aggregation operation on the orders collection converts the order_date to date before sorting by the date value: // Define stage to add convertedDate field with the converted order_date valueHi . You can choose whether functional and advertising cookies. See Join Your Data for more information. Thanks for your help . step 1 : I do teaming for interface A & B, enable LACP on virtual teaming interface. Here is a slimmed down version what I'm trying to do. Refresh. If your are trying to find the minimum of your [Date] field by your [Author] field, you might want to construct a LOD calculation to find first date, by author like so: //Creates calculated field for [First Date by author] {FIXED [Author] : MIN ( [Date])} You also have asked about 'double aggregating'. What that will do is return a single record, the most recent transaction for each branch id (all other transactions will have a null blend ID) - then you can do a count. Better yet, you can use SUM(Number of Records) instead of COUNTD([DR Number]) because that data source appears to only have one record per [Dr Number]. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. If. 12. Good morning - see the attached. CSS ErrorIf I create my calculated field without using an aggregation with {Profit}, QuickSight doesn’t know from which row to get the value. Another view with the details. When projecting or adding/resetting a field within an embedded document, you can either use dot notation, as in. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. Hi Jim, Even if I don't join the 2 data sources and just blend them by "Region" and "Store Name", I still get "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" on dragging Total Utilized Money field into the view. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I have a another data set with SQL Server data source with 2 fields: Relationship and ID. If a query asks for sales figures for all soft drinks, the aggregate table should be used for Coke and Pepsi and the detail data for the other brands. RED FIELD Tableau Name of First Math Course= IF [Tableau Period of First Math. However I keep getting the following error: co. Some of my table calculation are the follow: RED FIELD Tableau Name of First Math Course= IF [Tableau Period of First Math Course]== [Academic Period] AND ( [Subject Desc]=='Mathematics' OR [Subject Desc]=='Mathematics. the second tab “by Industry”, if you try to filter by SBU or BU, “Held” or “Scheduled”3) Use aggregate measures instead of filters, for example by using ATTR(Dimension). In the Data pane, double-click a spatial field. When you import metadata, Framework Manager assigns values to the Usage and Regular Aggregate properties for query items and measures depending on the type of object that the query item or measure is in. So the only way, it was possible was to connect one of the data sources with a calendar table joined with previous year and then blend it against the same data to get the Current Year and Same Period Last Year. You can choose whether functional and advertising cookies apply. Restrictions. Argument to SUM (an aggregate function) is already an aggregation, and cannot be further aggregated. if [created at] = { fixed [branch id]: max ( [created at])} Then [branch id] end. addShard. java. NoDays >> * <<root. I read that this is not possible. Jim. I've tried that in the past, and I was always blocked by the unsupported aggregation message. Right-click the field you are aggregating and select Properties. Additional summary functions are available in the expression editor. The version I am working with 10. If you need to use an unsupported operation in an aggregation, you must define the entire expression using the BSON Document type. id) FROM table_b b WHERE b. Hadoop provides two fs interfaces - FileSystem and AbstractFileSystem. You can choose whether functional and advertising cookies apply. For example am having column called "Name" in my first data source, in second data sources am having column called "F Name". Sorting by a tuple with 2 values is much slower. Error: Cannot Blend the secondary data source because one or more fields use an unsupported aggregation. For more information on blends, check this out: Blend Your Data - Tableau . In the Name field, enter OldPasswordAllowedPeriod, and then press the Enter key. Windowed aggregations partition the results from a SQL query into groups in order to perform calculations across adjacent rows of the query result. Claims Paid for Treatment and Testing. 1, is the pass-through expression. on Rows, Columns, Pages, or the Marks Card. Sub-path [interactions-c] points to non single-bucket aggregation" } } ] }, "status" : 500 } this is my index mapping:DataFrameGroupBy. conf already had the field temperature created in my influx database from previous tries with its type set as last. Cannot blend the secondary data source because one or more fields use an unsupported aggregationFollow this link for more information:We use three kinds of cookies on our websites: required, functional, and advertising. I created a parameter with a simple calculated field so that I may toggle between two measures. clients. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. QSS Overview; QuRouter. The version I am working with 10. Aggregates in the materialized view query must be outputs. We use three kinds of cookies on our websites: required, functional, and advertising. No, the intention of the composite agg is to provide a way to systematically page through all results. non-currency measure. Try loading pyspark functions with an alias instead:. Non-aggregate measures do not perform any aggregation and thus will not perform a double. 1 Connected to Tableau Server as Main DS and Live Connection to an excel file as secundary DS . Tommy Sims (Member) Set the table calculation to COMPUTE USING using the KM Date field. There are corresponding countToAggregation , countDistinctToAggregation etc. You can't directly use concat function with window function. CSS ErrorHi Ben, This comes from my own explorations and got confirmed by the Tableau dev who built the latest version of data blending (called DB2). Make sure that you are blending on dimensions present in the view or on all of the. And now if I bring that Fixed calculation ( called as "Duration" in my worksheet. filters on the worksheet, so we cannot drop filters out from the worksheet. I made a calc that mimicked your group, and if I use that on colors, the sheet works as you want. You can use inner select for this case: where daftar. Option 1: Include all linking fields in the view, and aggregate secondary fields Data blending will work when the secondary data source uses logical tables, as long as the following conditions are met:. To achieve this you need to add Calculated Field to an Analysis ( as described here ). 5 and have 2 data sources RPT and AD in the workbook which are currently extracts. I have some problems when I try to blend my secondary with my main data. You'll always want to return the same type, so that in itself could be an issue. Golang mongodb aggregation using mongo-driver. At this time the only use case that I run into (for me and the folks that I help out) for data. This optimization can be applied to functions for which the following property holds f(S1 UNION ALL S2) = f(f(S1) UNION ALL f(S2)). Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Tommy Sims (Member) 7 years ago. Aggregation consistency; In order to create a calculated field with aggregated fields in the calculation, ALL fields must be aggregated or not aggregated, you cannot have a mixture of aggs vs nonaggs in the CF. keep the dimensions in the view. Click on the different cookie categories to find out more about each category and. ) Functions shown as accepting numeric_type are available for all the types smallint, integer, bigint, numeric, real, and double precision. To add aggregation to a field for a pivot table visual. After blending, CountD works fine on primary datasource, but when I try to use CountD on secondary datasource tableau gives error: "Cannot blend secondary data source as one or more fields use an unsupported aggregation"Hi, Where Tableau v9 introduced level of detail expressions and Tableau v10 introduced cross-data source joins there are a number of use cases where we previously needed data blending that we now don’t, so the first thing I always look at is whether we really need a blend to get the desired results Also there are various cases where the non. Thus I have this calc below . To achieve this you need to add Calculated Field to an Analysis ( as described here ). Error "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" when Data Blend… You may just be able to turn the Excel file into an extract to overcome this, but I'd have to test/see the data & workbook to be certain. e. Wrong aggregation type for query. t Link Aggregation. If I use the parameter from the secondary data source, I get the following error: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". this is the sample of getUser function public async getUser(aggregate: o. I have two datasets; one is a shape file that contains regions and locations. CallTime Avg (internal)>> because CallTime Avg (internal) is interpreted as being. Cannot blend the secondary data source because one or more fields use an unsupported aggregation Did some research on this and found plenty of "workarounds" with no. Cyb3rWard0g changed the title Elastalert Integration - Elastalert Integration - Unsupported feature 'near' aggregation operator not yet implemented Dec 9, 2018. And I want to add one of the field from secondary dataset to be in the filter. unsupported aggregation from blended data problem. MULTI_SOURCES_UNSUPPORTED_FOR_EXPRESSION. Loading. Click on the different cookie categories to find out more about each category and. calculated. You can specify collation for a collection or a view, an index, or specific operations that support collation. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. Hi Folks, I am trying to solve a typical requirement (at least for me ). I need my calc to run on the row level irrespective of the view. Each output table from an aggregate function will: Contain a single record. Go to a new worksheet. Hi Judy, Could you try 'swapping' the datasources, so the one with the [Customer_Code] would become your Primary? You could do it just for one view,Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep.