topic Re: Excel Data Modification in App Development

Excel Data Modification

useri123 — Mon, 24 Jun 2024 11:19:45 GMT

Image 1 is the excel file,image2 is the required output, what script can be used in qliksense for that output?

Re: Excel Data Modification

Or — Mon, 24 Jun 2024 11:35:26 GMT

I don't see any relationship between the lines, but if it's always two consecutive lines, peek() should work.

Re: Excel Data Modification

Digvijay_Singh — Mon, 24 Jun 2024 12:58:06 GMT

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;

Re: Excel Data Modification

useri123 — Tue, 25 Jun 2024 05:47:35 GMT

Hi,the input file is excel, what can be done for that instead of inline?

Re: Excel Data Modification

useri123 — Tue, 25 Jun 2024 05:53:53 GMT

DataFile