Hello,
I was wondering if I could get some help please.
I am attempting to reformat a large set of data to load into qlikview. At the moment there are multiple columns with values on one line separated by a comma. I would like to find a way to separate the data for all of the columns. I have included a small sample below.
<colgroup><col span="2"><col><col><col><col><col><col><col span="2"><col><col span="5"><col></colgroup><tbody>
</tbody>
Please let me know if you require further information.
Kind regards,
Esther
I was wondering if I could get some help please.
I am attempting to reformat a large set of data to load into qlikview. At the moment there are multiple columns with values on one line separated by a comma. I would like to find a way to separate the data for all of the columns. I have included a small sample below.
Full Name (Member) | Call Lead | Name | Product Group | Product Pitch Category | Call Method | Date & Time of Call | Call Purpose | Call Purpose2 | Subject | Summary Of Call | Rel ID | CPB Lead GEID | Deployment Region | Lead Banker (Relationship Name) | LeadBanker ID | CPB Employee IDs |
Name 1 | Lead 1 | Name 1, Name 2, Name 3, Name 4, Name 5, Name 6 | Product 1, Product 2, Product 3, Product 4 | Pitch 1, Pitch 2, Pitch 3 | Phone | 11/1/2017 | purpose 1, purpose 2, purpose 3 | Purpose 1 | Subject 1 | Summary 1 | ID 1 | 100001 | Region 1 | Banker 1 | 100011 | 100011, 100012, 100013, 100011, 100012, 100013 |
Name 2 | Lead 2 | Name 1 | Product 1 | Pitch 1, Pitch 2, Pitch 4 | Person | 11/2/2017 | purpose 1 | Purpose 2 | Subject 2 | Summary 2 | ID 2 | 100002 | Region 2 | Banker 2 | 100012 | 100011 |
Name 3 | Lead 3 | Name 1, Name 2, Name 3 | Product 1 | Pitch 1 | Phone | 11/3/2017 | purpose 1 | Purpose 3 | Subject 3 | Summary 3 | ID 3 | 100003 | Region 3 | Banker 3 | 100013 | 100011, 100012, 100015 |
Name 4 | Lead 4 | Name 1 | Product 1, Product 2, Product 3, Product 7 | Pitch 1 | Phone | 11/4/2017 | purpose 1, purpose 5 | Purpose 4 | Subject 4 | Summary 4 | ID 4 | 100003 | Region 4 | Banker 4 | 100011 | 100011 |
Name 5 | Lead 5 | Name 1, Name 2, Name 3, Name 4, Name 5, Name 10 | Product 1, Product 2 | Pitch 1, Pitch 2, Pitch 7 | Phone | 11/5/2017 | purpose 1, purpose 6 | Purpose 5 | Subject 5 | Summary 5 | ID 5 | 100003 | Region 5 | Banker 5 | 100011 | 100011, 100012, 100017, 100012, 100016 |
Name 6 | Lead 6 | Name 1, Name 2, Name 3, Name 4, Name 5, | Product 1, Product 2 | Pitch 1, Pitch 2, Pitch 8 | Person | 11/6/2017 | purpose 1, purpose 7 | Purpose 6 | Subject 6 | Summary 6 | ID 6 | 100003 | Region 6 | Banker 6 | 100011 | 100011, 100012, 100018, 100019 |
Name 7 | Lead 7 | Name 1, Name 2, Name 3, Name 4, Name 5, Name 12 | Product 1, Product 2, Product 3, Product 10 | Pitch 1, Pitch 2 | Phone | 11/7/2017 | purpose 1 | Purpose 7 | Subject 7 | Summary 7 | ID 7 | 100003 | Region 7 | Banker 7 | 100011 | 100011, 100012, 100012, 100018, 100019, , 100020 |
Name 8 | Lead 8 | Name 1 | Product 1, Product 2, Product 3, Product 11 | Pitch 1, Pitch 2 | Person | 11/8/2017 | purpose 1, purpose 9 | Purpose 8 | Subject 8 | Summary 8 | ID 8 | 100003 | Region 8 | Banker 8 | 100011 | 100011 |
Name 9 | Lead 9 | Name 1 | Product 1, Product 2, Product 3 | Pitch 1, Pitch 2, Pitch 11 | Person | 11/9/2017 | purpose 1, purpose 10, purpose 12 | Purpose 9 | Subject 9 | Summary 9 | ID 9 | 100003 | Region 9 | Banker 9 | 100011 | 100011 |
Name 10 | Lead 10 | Name 1, Name 2 | Product 1 | Pitch 1, Pitch 2, Pitch 12 | Phone | 11/10/2017 | purpose 1 | Purpose 10 | Subject 10 | Summary 10 | ID 10 | 100003 | Region 10 | Banker 10 | 100011 | 100011, 100012 |
Name 11 | Lead 11 | Name 1, Name 2, Name 3, Name 4, Name 5, Name 16 | Product 1, Product 2, Product 3, Product 14 | Pitch 1 | Person | 11/11/2017 | purpose 1, purpose 13 | Purpose 11 | Subject 11 | Summary 11 | ID 11 | 100003 | Region 11 | Banker 11 | 100011 | 100011, 100012, 100023, 100022, 100012, 100021 |
<colgroup><col span="2"><col><col><col><col><col><col><col span="2"><col><col span="5"><col></colgroup><tbody>
</tbody>
Please let me know if you require further information.
Kind regards,
Esther