requirement on Calendar object

Wed, 25 Nov 2020 16:16:04 GMT

Hi guys

i have Created on Calendar object with Quarter field.my output should be like this

Expected O/P: Q1,Q2,Q3,Q4

Actual O/P: Q,Q1,Q2,Q3,Q4

how to clear this Q field

Re: requirement on Calendar object

sunny_talwar — Mon, 07 Mar 2016 20:54:52 GMT

May be this:

If(Len(Trim(Date)) > 0, 'Q' & Ceil(Month(Date)/3)) as Quarter

Mon, 07 Mar 2016 21:02:22 GMT

Can you use QVC for calendar Master just rigth there:

CALL Qvc.CalendarFromField('LinkTable.Periodo');

Rename Table MasterCalendar To D.CalendarioTmp;

Rename Field Day To Calendario.NumDia;

Rename Field Weekday To Calendario.DiaSemana;

Rename Field Month To Calendario.Mes;

Rename Field Year To Calendario.Anno;

Rename Field Quarter To Calendario.Trimestre;

Rename Field [Year-Month] To Calendario.AnnoMes;

//--------------------------------------------------------------------------------------------------

// Procesamiento de la Tabla en Memoria para Crear Columnas Nuevas...

_Calendario:

LOAD Distinct

AutoNumberHash256(Date(Calendario.AnnoMes, 'YYYYMM')) as SK.Periodo,

Date(Calendario.AnnoMes, 'YYYYMM') as Calendario.Periodo,

Calendario.Anno,

Calendario.Mes,

Calendario.Trimestre,

Calendario.AnnoMes

RESIDENT D.CalendarioTmp;

DROP TABLE D.CalendarioTmp;

Only Change Linktable.periodo, for your field request.

I attached the QVC.

Mon, 07 Mar 2016 23:18:53 GMT

Thanks

Mon, 07 Mar 2016 23:19:25 GMT

Thanks