How to fill column (A) based on corresponding column (B)

[Anonymous]

Hi Community,

My dataset includes financial transactions, for example a few columns:

I would like to fill column CREDITOR with "1000" because JOURNALNUMBER is equel to other rows.

Could anyone help me with this please? Thanks a lot!

Grtz,

Pascal

[OmarBenSalem]

Would this work?

[OmarBenSalem]

or this?

t:

load * Inline [

CREDITOR,COSTPLACE,JOURNALNUMBER

1000,,20180001

,4000,20180001

200,4000,20180001

2000,300,20180002

,3000,20180002

500,4000,20180003

];

NoConcatenate

load  if(len(CREDITOR)=0,peek(CREDITOR),CREDITOR) as CREDITOR_New,

CREDITOR,

JOURNALNUMBER , COSTPLACE Resident t Order by JOURNALNUMBER;

drop Table t;

[quriouss]

Would it work to do a JOIN?

(untested:)

Table1:

Load

     CREDITOR as CREDITORTEMP,

     COSTPLACE,

     JOURNALNUMBER

From file.qvd;

Left Join (Table1)

Load

     CREDITORTEMP as CREDITOR,

     JOURNALNUMBER

Resident Table1

Where Isnotnull (CREDITOR);

Drop Field CREDITORTEMP;