Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear specilialist,
I need to fill fields without value with the previous value in that field
So :
25 A
778
44
55
77 B
44
12
12 C
33
Needs to become:
25 A
778 A
44 A
55 A
77 B
44 B
12 B
12 C
33 C
I tried to use Peek() and Previous() but that doesn't work. Maybe I am using it wrong.
Please take a look at the atteched files.
PS my orginal data is not in Excal so I can not use the fill function in the wizard
Hi you just need to reference your renamed field A2 in peek function:
LOAD If (ISNULL(A), Peek(A2) , A) as A2,
B as B2
FROM
Schedule.xlsx
(ooxml, no labels);
Regards,
Stefan
Hi you just need to reference your renamed field A2 in peek function:
LOAD If (ISNULL(A), Peek(A2) , A) as A2,
B as B2
FROM
Schedule.xlsx
(ooxml, no labels);
Regards,
Stefan
Yes that's it. I overlooked that.
Thanks!