I have a problem with my split activity in adobe campaign classic
The issue is the complement set of split activity is not giving the results,it always gives the total number records passed to the split activity in the workflow
I am sharing my screen captures here
I am looking forward someone's help resolving this issue.
You forgot to define the sort criteria (order by), please select a field of your filtering dimension.
I have selected the field of my filtering dimension, still it is not giving the right complementary set.
Ok 1st mistake repaired, now I think you should address the 2nd one; please select the 1st checkbox because you didn't use a criteria of your additional data to do the split but directly the targeting dimension "Data_loading (RDBMS)" (actually the primary key is used, because it is done with a top instruction) :
Thanks for your reply, sorry for the duplicate thread,
If select the first radio button, it automatically comes to use additional data only, still I am seeing the same issue, complementary set is not giving the correct records.
The first activity in the workflow import the data from the external database, there is no primary key(mid) is not primary key there.
Sorry Vaidehig if your criteria to select comes from the external data source, so it is the 3rd choice radio button that you must choose.
This is the configuration for Data Loading activity, we are importing it from external Data source,then the data is coming to Split activity, then no need to again configure the external data source in split activity right, that is my understanding, please correct me I am wrong,
I'm having the exact same problem. I have a split following another split. No matter what I seem to do though, the matches go down one path, but the complement still has all of the records. For example:
Split 1: Matches 10,000 records
Split 2: Matches 1,000 records, but the complement still has 10,000 records
Settings for my account type split
can you try the 3rd checkbox please ?
I Had the same problem also.
Found out that if there is no primary key in the inbound temp table then the complement is not working correctly.
So I needed to use one of two options:
1. keep a key field in the temporary table.
2. Adding another transition to the split and specify the complement rule instead of using the complement.
for example if the split is for 'age >18' then instead of using complement, add another out transition to the split specifying 'age<18' (and remove the check box from the complement)