Logical Help

[Anonymous]

Greetings,

I want to add a column called "Traded" requirement  is such that if a customer has traded with in its invoice date then it should show value 'Traded' else 'Not Traded'.

[vishsaggi]

What is the field used here for CustomerTradeDate?

May be you can try like:

LOAD *,

         IF(CustomerTradeDate <= InvoiceDate, 'Traded', 'NotTraded')  AS TradeFlag

FROM yoursourcename;

[Anil_Babu_Samineni]

May be this?

Load Field1, Field2, customer, [invoice date], If(customer <= [incoice date], 'Traded','Not Traded') as Traded

From <Datasource>

[Anonymous]

there is no column such like  date

[vishsaggi]

So how you going to check if that customer is within the InvoiceDate, there should be some datefield right?

[MarcoWedel]

It would help you to get answers if you provided information about existing fields in your data model instead of non existing ones ...