how to populate the field values according previous field value

[raji6763]

hi ,

i want  to populate the field values according previous field value

1	key1
1
Raju
1
2	key2
2
cbe
2
3	key3
3
3
3

expected output:

thanks

[brunobertels]

add this in your script 

if(len(trim(Key1))>0,Key1,peek(Key1)) as Key1 

[raji6763]

i can see the field vales in next column only. i want to populate fully

[tresesco · Accepted solution]

This?

Load fieldvalue,
	if(len(trim(Key))=0, peek(Key), Key) as Key
Inline [
fieldvalue, Key
1, key1
1, 
Raju, 
1, 
2, key2
2, 
cbe,
2,]

[raji6763]

@tresesco  please find attached file

[tresesco]

Output table is missing in the attachment. Try to include that and re-attach. Also, comment/like/close this thread requirement.

[raji6763]

[tresesco]

Rajib,

This is probably a case of generic database, however in your sample case there is missing a association KEY. That means, name, address and age values are fine, but there is no link/association link. For ex, how can you say that Raju's address is 'cbe' and age is '12' ? why not 'try' and '14' respectively?

Hope I could make it clear.  

[raji6763]

how to convert this into below output:

output:

[tresesco]

Check it here:

https://community.qlik.com/t5/New-to-Qlik-Sense/covert-rows-to-columns/m-p/1722622/highlight/false#M...