Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
this should work
Table:
LOAD
Rowno(),
if(len(trim(DEPT))=0,peek('DEPT'),DEPT) AS DEPT
FROM [your_data_file.
csv]