topic Re: Column name need for each row in QlikView

Column name need for each row

Wed, 23 Apr 2014 04:30:41 GMT

hi all

i have data like attached below

Col1	col2	col3	col4	col5	col6	col7	col8	col9	col10
a	1	x	4	d	7	g	xyz	aa	0
b	2	y	5	e	8	h	xyz	bb	0
c	3	z	6	f	9	i	xyz	cc	0

in script level itself i need to convert my data like i attached below

Col1	col2	col3	col4	col5	col6	col7	col8	col9	col10
a	1	x	4	d	7	g	xyz	aa	0
Col1	col2	col3	col4	col5	col6	col7	col8	col9	col10
b	2	y	5	e	8	h	xyz	bb	0
Col1	col2	col3	col4	col5	col6	col7	col8	col9	col10
c	3	z	6	f	9	i	xyz	cc	0

any idea!!!!

thanks

Re: Column name need for each row

sujeetsingh — Wed, 23 Apr 2014 04:39:17 GMT

just reload the table once stacked with loading 1 st row then 2nd row ......etc

Or just do a trick of concatenating more than one table

Re: Column name need for each row

Wed, 23 Apr 2014 04:40:59 GMT

hi sujeet,

thanks alot for ur kind reply.

will u plz explain me a bit detailed please

thnx

Re: Re: Column name need for each row

Wed, 23 Apr 2014 05:04:31 GMT

Hi ,

Like this

Qualify *;

Table1:

Loald *

From YourSource

Where Col1='a';

Table2:

Loald *

From YourSource

Where Col1='b';

Table3:

Loald *

From YourSource

Where Col1='c';

UnQualify *;

Note: If you don't use Qualify, Auto concatenation will happen.

If you use noConcatenate, Synthetic keys will create in your model.

Hope it helps you..!

Re: Column name need for each row

Wed, 23 Apr 2014 05:08:58 GMT

hi ravi,

i cant use where col1='a' somthing like that. because it may be anything and of i have 100000 rows i cant do one by one rite.

please suggest is thr any other way to achieve my desired result

thnx

Re: Column name need for each row

sundarakumar — Wed, 23 Apr 2014 05:09:18 GMT

Pls explain..

Are Col1,col2,col3.... field names?

IF Col1, col2,... are field names, do u want the field name to be long with data in the alternate rows? or u want to have different tables with the fileds col1, col2,... with only one row each.?

If so y do u need it in that format? How are u planning to show data with the field names inside the data.

are these col1, col2... are just data?

-Sundar

Re: Column name need for each row

Wed, 23 Apr 2014 05:14:35 GMT

hi sundar,

col1, col2, col3 are field name

do u want the field name to be long with data in the alternate rows?

Yes i need to show field name infront of each and every row

Re: Column name need for each row

sundarakumar — Wed, 23 Apr 2014 05:25:22 GMT

Y so? How are u planing to show data in the dashboard with the field names mingled in along with the data.?

What would be the purpose of inserting the field names into the data? can u pls explain

-sundar

Re: Column name need for each row

sundarakumar — Wed, 23 Apr 2014 05:40:36 GMT

Ur requrirementr can be done with a for loop and cancatenation.

This could be dont in the following way.

1. create a new key in the table as below
rowno() as newkey

table1:
load col1,col2,
rowno() as newkey

from source;

2.now create an inline table with the same field names, but the data as the field names itself.

table2:
load * inline
[col1,col2,newkey
col1,col2,newkey];

3.now load only one row of data from table 1 and concatenate to table2
4.concat table2
5.load the second row from table1 and concatenate to table2
6. concat table2

7. for loop can be written to repeat 3,4,5,6,....

8. after loading it in the desired format, drop table1.

Hope this helps.

-Sundar

Re: Column name need for each row

Wed, 23 Apr 2014 05:52:57 GMT

hi sundar,

thnk u very much for ur reply. i am very new to qlikview. will you please share me the script. how exactly we can do it..

thnaks

Re: Column name need for each row

sundarakumar — Wed, 23 Apr 2014 06:33:28 GMT

Can u pls tell me the purpose of this? there could be som other ways or funtions to fulfill ur requirement. instead of putting the field names in the alternate rows.

Can u pls explain the req?

-Sundar

Re: Column name need for each row

Wed, 23 Apr 2014 07:58:42 GMT

i need to give this as a text file... they need to use this as a input data to some other system that why

Re: Column name need for each row

sundarakumar — Wed, 23 Apr 2014 08:26:54 GMT

Pls share a sample source file.

-sundar

Re: Re: Column name need for each row

Wed, 23 Apr 2014 08:38:12 GMT

pfa