Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi comminity,
I have a table like a following one
Field 1 | Field 2 | Field 3
A test1 fjhafjhf
A fjhsfjhf
A jfhuhf
A test2 fjskfhdkf
A fjkksafjfads
B fhagdhsgd
B sijisjff
C dfjfjfk
Expected outcome
Field 1 | Field 2 | Field 3
A test1 fjhafjhf
A test1 fjhsfjhf
A test1 jfhuhf
A test2 fjskfhdkf
A test2 fjkksafjfads
B fhagdhsgd
B sijisjff
C dfjfjfk
Im loading several excel files and each one has 1 table like the first.
i want to do a cycle for each file to do this table a peek field2 a replace the null value for above until field1 is A. when b appear on field 1 stop fill and let the empty space.
I tryed some differente ways nothing seems to work.
Any ideas?
Thanks in advance
Best Regards,
Bruno Paulo
Hi Bruno,
Have you seen this post? Generating Missing Data In QlikView
The example "Propagate a value downwards " covers your situation, though you will need to add another test to check if Field1 = peek(Field1) to see if the value has changed from the previous row.
Did you check the wizard when creating the script? under "Transform" and then "Fill"?
Try like this in the script
if( len(trim(Field2))=0,peek('Field2'),Field2) as Field 2
Yes, but i dont like wizard. It only makes static codes. For this case can result but any change on excel file will return errors.
Hi Bruno,
Have you seen this post? Generating Missing Data In QlikView
The example "Propagate a value downwards " covers your situation, though you will need to add another test to check if Field1 = peek(Field1) to see if the value has changed from the previous row.
Exactly what i needed. (couldnt found this, thank you!)
with some work this result as well thank you!
Best Regards
Bruno