To show new order

[tan_chungkam]

Hi fellas,

I have 2 excel files which are May and June sales report.

The table in each file basically look like as below shown.

I would like to create a column which shows the order whether it is a new order or existing order.

Thus, i looking for a formula / function - if the order no. appear in last month then it is an existing order. if the order no. do not appear in last month then it is a new order.

Is there any function to do that?

Month	Order no.	Order Type	Delivery week
Jan	1111111	New Order	201803
Jan	2222222	New Order	201805
Jan	3333333	New Order	201804
Jan	4444444	New Order	201811
Feb	2222222	Existing Order	201808
Feb	4444444	Existing Order	201811
Feb	5555555	New Order	201812
Mar	4444444	Existing Order	201815
Mar	5555555	Existing Order	201815
Mar	6666666	New Order	201818

Thanks.

[Anonymous · Accepted solution]

hello

maybe something like that

load

*,

if(previous([Order no.])<>[Order no.],'New','existing order') as NE

resident sales_report

ORDER BY [Order no.];

[olivierrobin]

hello

load first month

concatenate 2nd month

add a column

if(exists(Order no),1,0) as flag_exist

[Anonymous]

hello

maybe something like that

load

*,

if(previous([Order no.])<>[Order no.],'New','existing order') as NE

resident sales_report

ORDER BY [Order no.],Month;

[rajeshqvd]

if(exists([Order no.]),'Exit Order','New Order') as [Order Type]

[tan_chungkam]

hi rajeshqvd‌

where should i put the formula?

should i put the expression into the 'add a column by using measure'?

or should i put it into the data load editor?

Really appreciate your help.

[rajeshqvd]

Yes put it into the data load editor