Expression in Script

[#1]

Good day

I have a data source from excel as below:

Position	Value
	Qty
1	ARBUE
2	UYMVD
	Cost
3	ARBUE

i want to create a condition that creates a third column (KEY) as below:

if (Position = '', Value, 'an expression that copy the row above in KEY column')

I'm not able to find this expression or any another solution for this.

Position	Value	KEY
	Qty	Qty
1	ARBUE	Qty
2	UYMVD	Qty
	Cost	Cost
3	ARBUE	Cost

[lironbaram · Accepted solution]

hei

use this expression in the load script

if (Position = '', Value,peek('KEY') as KEY

[#3]

perfect, tks!

[#4]

liron baram wrote:

hei

use this expression in the load script

if (Position = '', Value,peek('KEY') as KEY

hi.
It does not work for me.

Can you publish the entire script?

Thanks,
Daniel

[#5]

hi.
It does not work for me.!

Can you publish the entire script?

Thanks,
Daniel

[#6]

Hi.
It does not work for me. Can you publish the entire script?

Thanks,
Daniel

[#7]

Daniel, pls check if this can help you:

LOAD

     Position,

     Value,

     if (Position = '', Value, peek(Position)) as KEY

FROM [...]

Rgds,