topic Re: RTDM dataprocess step, handling list variables from input in SAS Customer Intelligence

RTDM dataprocess step, handling list variables from input

jlandz — Wed, 24 Jan 2018 20:30:45 GMT

Enahcning a decision campagin in customer intelligence studio tool, with a DATA PROCESS STEP.

Granularity. the goal for me is taking in 'list' variables or an array of variables, and for each nth element, insert a row in my table defined in the data process step. the table is sql server and tne need is to do a row insert.

I have a request call coming into my decision campaign, in customer intel studio. it has a number of vehicles for example from one request I can have a vecchile[1], vehicle[2], vehicle [3] each coming in as a list variable. my goal is to have the data process step insert one row for vehicle[1], and another for [2] and [3]. and yes there is redundant data on each record from the request variables and that's still a good thing, the other non array variables we still want to repeat on these inserts even though they are redundant.

How do I wire up the diagram without adding multiple data process objects. is there a sophisticated way of doing this?

so the picture is, I have a RQST-> RTDM-->INSERT INTO THE DATA PROCESS STEP 1-MANY ROWS --> RESPONSE BACK.

anyone out there accomplish this? other examples have all been forward 1:1 relationships. we store a requests inputs and the responses outputs. I want to do the same thing but my granularity is one to many.

Re: RTDM dataprocess step, handling list variables from input

ampdietrick — Mon, 29 Jan 2018 16:07:51 GMT

You will most likely need to create a SAS Process using custom DS2 code to accomplish your goal.

Re: RTDM dataprocess step, handling list variables from input

jlandz — Wed, 31 Jan 2018 00:37:24 GMT

thanks. ok, so embed the ds2 in a sas process step as a node in the flow. then I wonder if would wire up in the campaign flow "data process node" ---> data process step. my ds2 would , output out, each nth set of values for my array. I could play with this.

Re: RTDM dataprocess step, handling list variables from input

jlandz — Thu, 01 Feb 2018 15:20:43 GMT

the other option I'm thinking as adding it to the decision treatment flows. that is the granularity care for. we will try this out.