peek

[Mahamed_Qlik]

HI

We have data as below in pivot format and needs to convert as in table format.

Rowno()	DEPT
1	IT
2
3
4	Finance

Output expected :

Rowno()	DEPT
1	IT
2	IT
3	IT
4	Finance

We have used peek function in script editor but only returning first 2 rows

if(len(trim(DEPT))=0,peek('DEPT'),DEPT) AS DEPT

Also tried above function in chart but no luck.

our requirement it needs to be done in backend script.

kindly assist.

[Chanty4u]

 this  should work 

Table:

LOAD 

    Rowno(),

    if(len(trim(DEPT))=0,peek('DEPT'),DEPT) AS DEPT

FROM [your_data_file.

csv]