Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have two fields FROM DATE & TO DATE. It is monthly data. I need to create month name field using these two dates
FROM DATE | TO DATE |
---|---|
2018-01-01 | 2018-01-01 |
2018-01-01 | 2018-03-01 |
2018-02-01 | 2018-02-28 |
2018-03-01 | 2018-03-31 |
I need month name
Hi Apoorva,
Try like this:
First create a master calendar using min(From Date) and Max(To Date) and Name it "Date" field.
Then:
A:
Intervalmatch(Date)
Load distinct
[To Date],[From Date] resident <Yourtable>;
Br,
KC
Use Month(FROM DATE) and Month(TO DATE)
HI Apoorva,
Use:
'TableName':
Load
Date(Month([FROM DATE]),'MMMM') as MonthFromName,
Date(Month([TO DATE]),'MMMM') as MonthToName
Can you post your expected result as well based on your sample data?
I can think like this?
Table_Load:
Load [FROM DATE] as DateField From Table;
Join
Load [TO DATE] as DateField From Table;
Final:
NoConcatenate
Load DateField, Month(DateField) as Month Resident Table_Load:
Drop Table Table_Load;
give example using interval match
could you give the same output required ?
Hi Apoorva,
Try like this:
First create a master calendar using min(From Date) and Max(To Date) and Name it "Date" field.
Then:
A:
Intervalmatch(Date)
Load distinct
[To Date],[From Date] resident <Yourtable>;
Br,
KC