Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
hei
use this expression in the load script
if (Position = '', Value,peek('KEY') as KEY
hei
use this expression in the load script
if (Position = '', Value,peek('KEY') as KEY
perfect, tks!
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
hi.
It does not work for me.!
Can you publish the entire script?
Thanks,
Daniel
Hi.
It does not work for me. Can you publish the entire script?
Thanks,
Daniel
Daniel, pls check if this can help you:
LOAD
Position,
Value,
if (Position = '', Value, peek(Position)) as KEY
FROM [...]
Rgds,