I have uploaded a list in a workflow and I am trying to query the value of the 1st for the 1st row as well as the value of the 1st column for the 2nd row, the whole thing to be used in dynamic content.
Is there any way to do it in Adobe Campaign?
In the table below, I would like to use the <%= targetdata.Value1 %> which correspond to 12 as well as the second row. The challenge we have is that each value corresponds to the primary key queried, therefore we would need to add a selection of the next row.
That time I thought you can use instance variables in the delivery but the truth is I used them in the Alert message activity and not in delivery. You need to map instance variable to delivery variable as Amit wrote.
The setup looks like this:
The alert code is the following:
I have not added all the Node expressions in the output as I just want to run a test at the moment. However, I get this error message:
XSV-350122 An error occurred and the process has been stopped.
SOP-330011 Error while executing the method 'PrepareTarget' of service 'nms:delivery'.
SOP-330011 Error while executing the method 'PrepareTargetImpl' of service 'nms:delivery'.
DLV-490009 You have not defined the target population of the delivery action
Which is weird as I have defined the target to "operators" and assigned myself to the alert.