Create a table based on comma seperated values

Thu, 21 Jan 2010 15:26:20 GMT

<body>Hello everyone I want to write a generic script which can be better explained as follows: <table width="333" cellpadding="0" cellspacing="0" border="0" style="width: 250pt; border-collapse: collapse;"> <colgroup><col width="64" style="width: 48pt;"></col><col width="269" style="width: 202pt; mso-width-source: userset; mso-width-alt: 9837;"></col></colgroup> <tbody> <tr height="17" style="height: 12.75pt;"> <td width="64" height="17" style="background-color: transparent; width: 48pt; height: 12.75pt; border: #ece9d8;">USER</td> <td width="269" class="xl63" style="background-color: transparent; width: 202pt; border: #ece9d8;">Values</td> </tr> <tr height="17" style="height: 12.75pt;"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8;"></td> <td class="xl63" style="background-color: transparent; border: #ece9d8;"></td> </tr> <tr height="17" style="height: 12.75pt;"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8;">One</td> <td class="xl63" style="background-color: transparent; border: #ece9d8;">4500, 6700</td> </tr> <tr height="17" style="height: 12.75pt;"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8;">Two</td> <td x:num="2.1" class="xl63" style="background-color: transparent; border: #ece9d8;">2,1</td> </tr> <tr height="17" style="height: 12.75pt;"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8;">Three</td> <td class="xl63" style="background-color: transparent; border: #ece9d8;">23, 2420, 6451</td> </tr> </tbody> </table> For each user, I would like to create a table with a separate row for each value found ie <pre class="jive_text_macro jive_macro_code" jivemacro="code" ___default_attr="plain"> One, 4500 One, 6700 Two, 2 Two, 1 Three, 23 Three,2420 Three, 6451 </pre> I kinda know that one has to create a FOR EACH loop or a WHILE loop and create a new table but the syntax of it escapes me. How do I create a script in QV that reads in this table and for each user, seperate the values found in the Values field and create a new row? All help much appreciated!</body>

Create a table based on comma seperated values

hector — Thu, 21 Jan 2010 15:38:34 GMT

HI, you don't have to use a for/each statement

with this script i did what you want


LOAD
 USER,
 subfield(Values,',') as Value
INLINE [
 USER;Values
 One; 4500, 6700
 Two; 2,1
 Three; 23, 2420, 6451
](delimiter is ';');

i've changed the delimiter, just to adjust he format

rgds

topic Create a table based on comma seperated values in QlikView

Create a table based on comma seperated values

Create a table based on comma seperated values