Create FirstOrderMonth and OrderMonth

[madhuqliklondon]

Hi all,

I have datefield "Orderdate" from this I would like to create two columns "customerfirstordermonth" and "customerordermonth" .What I am trying to do is see how customers are buying behavior over the time from their first order. Could you please guide me .

Example:

Customer no	Ordernumber	Orderdate
1	123	01/01/2017
2	124	05/01/2017
3	125	10/01/2017
4	126	15/01/2017
1	320	10/02/2017
2	325	15/02/2017
3	330	20/02/2017
4	335	25/02/2017

In the above example customer no 1 shopped in 1st Jan so I would to track it as his"customerfirstordermonth" - Jan2017  and order again in Feb track it as "customerordermonth" - Feb2017.

Thanks in advance.

[madhuqliklondon]

I have to do this for tabs : J ,uk, Mir,Uk_arch,ems and FR.

[sunny_talwar]

You are doing concatenate, but to do this, you will have to first create a temptable and then left join to the temptable and then concatenate

TempTable:

LOAD....

FROM ...;

Left Join (TempTable)

LOAD ...

Resident TempTable;

Concatenate (...)

LOAD *

Resident TempTable;

DROP Table TempTable;

[madhuqliklondon]

I will try that Sunny.