Hi all,I have created an extension table for the nms:recipient table and
joined there another view of the datamart.Here is the code snippet: This join
works fine when you are are searching for instance for the first name,
last name and city, which is linked in the joined view.But when I try do
set a filtering statement for instance "city = 'Berlin'" then I got a
error message like this.It seems, that the missing external table can
not be inserted in the from clause of the SQL statement.Is thi...
Inside the workflow that creates recipients, there should be an Update
Data activity where you are perforning inserts.You will have to add a
new element i.e. Folder and specify the folder with which you wish to
tag these recipients.Every Recipient has a link with schema xtk:Folder.
If you don't fill the correct value for this link, all recipients are
created with folderid as 0 and hence you cannot view them in Explorer
view.Hope this helps.Regards,Vipul
Generally in AC6 while you define an extension schema to modify an
out-of-the-box schema, you make changes to the corresponding form
directly in the factory form. Is this the approach you have taken?Linda
Hi Tristian,I believe you are using a File Loading activity for pulling
in records from external table.Error message says that for insert/update
in recipient, reconciliation has been set to make use of targeting
dimension directly. But the incoming population to Update data activity
is not having any targeting dimension associated with it. Thus causing
the error.You will have to switch to reconciliation keys for identifying
that a record exists or not in recipietn schema.For more inputs please
Hi Tristan,You can use the query activity. When defining filtering
condition select targeting and filtering dimension to be you FDA schema.
Define a filtering query like primary key > 0 to fetch all records in
one go.Connect this query activity to an Update data activityHope this
Hi all,I have created some data schema bases on views of a remote
database.When I try now to do an export of a package which contains this
data schemas I got this error.Can anyone of you give me an hint ?
Unfortunately this instance is based on a German system settings.Thanks