Adding Customerid to each parsed row.

sam334 · Post by **sam334** » Wed Aug 20, 2014 9:12 am

All, I have posted this before and successfully parsed the data as shown below.
Customer_id, Interaction_data
Adam, 12:10:07: Dialing12:10:07: Connecting12:10:07: ABC: abc:9433769781$100.88.77.0:878712:10:07: ABCD: 000012:10:07: Agent Initializing12:10:18: On Call12:10:18: Assigned to operator12:10:18: Waiting for Supervisor12:10:18: Waiting for Manager12:11:13: Call Ended12:11:13: Call Not connected

The issue is that, each row has a customer id (Adam in this case) key for which this particular record is inserted. Now, If I want to add same customer_id to each parsed row, what method should I follow.

I want like,
Adam,12:10:07: Dialing
Adam,12:10:07: Connecting
Adam,12:10:07: ABC: abc:9433769782$100.88.77.0:8787
Adam,12:10:07: ABCD: 0000 and so one.
Thanks.

chulett · Post by **chulett** » Wed Aug 20, 2014 9:17 am

That just sounds like a stage variable to me. Stash it and add it to each row as you parse it.