I have a table called "Invocies" in which I have 2 fields, one is INVOICE DATE and another is ORDER DATE. I want to combined the dates and have one field called DATE
Below is the part of the scripting I've done to combine the dates.
Invoices:
LOAD *,
INVDATE as DATE,
ORDDATE as DATE
However I get the following error - "Filed names must be unique with table"
Where am i going wrong in my scripting. Please can you help.
You can't give two fields the same name. That would make it impossible to know from which field the value should be extracted.
Putting INVDATE and ORDDATE in one field doesn't make sense to me since they are very different things. But if you feel you must you then you need to do something like
Invoices:
LOAD *, INVDATE as DATE from ....etc;
LOAD *, ORDDATE as DATE from .... etc;
That will cause every invoice record to occur twice in the invoices table; once with INVDATE as DATE and once with ORDDATE as DATE. This sounds like a bad idea.
You should probably read this discussion about using common date dimensions and shared calendars.
Thank you. What im trying to achieve in the front end , i want to see the value of invoices or orders per day in one table, by selecting only one date, in this case its DATE (see table below)
I thought this discussion looked familiar. Did you follow Miguels advice? You should be all set to go then. Your combined table with orders and invoices will already have a DATE field, as well as the OrderDate and InvoiceDate fields. If you haven't followed his advice yet, do so now.
