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.
Adding Customerid to each parsed row.
Moderators: chulett, rschirm, roy
Adding Customerid to each parsed row.
Last edited by sam334 on Thu Aug 21, 2014 7:59 am, edited 1 time in total.