Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Image 1 is the excel file,image2 is the required output, what script can be used in qliksense for that output?
I don't see any relationship between the lines, but if it's always two consecutive lines, peek() should work.
As suggested by @Or solution depends on how your data looks like, I tried below peek and join combination, could be a better solution based on your situation -
input:
Load value_u2,id,if(len(id)=0,peek(id),'') as id1
inline [
value_u2,id
value1,88
value2,
value3, 78
value4,
value5,79
value6
]
;
NoConcatenate
temp1:
Load value_u2,id
resident input
Where len(id)>0;
NoConcatenate
temp2:
Load value_u2 as value,id1 as id
resident input
Where len(id)=0;
left join(temp1)
Load value,id
resident temp2;
drop table input,temp2;
Hi,the input file is excel, what can be done for that instead of inline?
DataFile