topic Re: Fill The Row Values in QlikView

Fill The Row Values

Fri, 10 May 2013 10:02:50 GMT

Hi guys

I have data in following format

q_id Values Detail

q1 0 A

1 B

q2 1 a

2 b

3 c

...........................

no of question ids.

I want data in given below format

q_id Values Detail

q1 0 A

q1 1 B

q2 1 a

q2 2 b

q2 3 c

...........................

In general filling below row value with upper q_id and it should be for every q_id. Is there any approach to do this in transformation step or any other idea.

//Tribhuwan

Re: Fill The Row Values

Fri, 10 May 2013 10:10:34 GMT

No Way.......... tribhuwan

how do u get this data xls or csv or txt

Re: Fill The Row Values

Fri, 10 May 2013 10:13:18 GMT

Hi Prashant

I am getting data in excel format. Are you sure there is no any other way to achieve it ?

//Tribhuwan

Re: Fill The Row Values

Gysbert_Wassenaar — Sun, 12 May 2013 14:37:19 GMT

Yes, use the Fill option of the Transformation Step.

The resulting load statement will look something like this:

MyTable:

LOAD q_id,

Values,

Detail

FROM comm81811.xlsx

(ooxml, embedded labels, table is Sheet1,

filters(Replace(1, top, StrCnd(null))) );

Re: Fill The Row Values

rustyfishbones — Sun, 12 May 2013 14:57:49 GMT

Gysbert,

What is the screen you are showing? I have not seen that before

Can you explain how I can see that step in the file wizard

Thanks

Re: Fill The Row Values

Sun, 12 May 2013 16:35:56 GMT

Hi Alan,

You can use the below script,

LOAD IF(ISNULL(q_id)=-1,PEEK(q_id),q_id) AS q_id,

Values,

Detail

FROM XYZ.xls

Regards

Ankur

Re: Fill The Row Values

Mon, 13 May 2013 06:35:36 GMT

Thanx guys for your help

I found that option in transformation step to fill below rows.

//Tribhuwan