Fill The Row Values

[#1]

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

[#2]

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

how do u get this data xls or csv or txt

[#3]

Hi Prashant

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

//Tribhuwan

[Gysbert_Wassenaar · Accepted solution]

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))) );

[rustyfishbones]

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

[#6]

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

[#7]

Thanx guys for your help

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

//Tribhuwan