Question
Running Data Flow in background for all the Customrs in Customer Table.
I have a use case where a Data Flow runs in the background everyday at a fixed time (say 6pm). It will fetch all the customers from the Customer Table who are below age of 18 and then it will run a strategy for all of them in order to specify certain offers.
As an output, I want to capture the CustomerID (from customer table) and the propositions assigned to each CustomerID in another table.
I used the below data flow.
Now, suppose there are 3 Customers with age below 18 and each got 2 offers each, then I have 6 entries in my Output table which is fine. But there is no customerID field there.
If the data flow is looping through each CustomerID in Customer Data Set, then where are those details of each of the customer stored. Can someone help me how to achieve this use case solution. And any other solution or suggestions if any.
From the tags you used, it sounds like you are using CDH 8.4. Given this fact, is there a reason you are trying to hand-craft this solution with low level constructs like data flow, instead of just using CDH and NBA Designer with engagement policies to limit your offers to 18 year olds and then emit the results to a file or DB template? Please see the course on Always-On outbound customer engagement in Pega Academy for details on how such use cases are accomplished with higher level constructs.