Functions On Inline Tables

[pgalvezt]

Hi, How can I use fuctions on Tables done with Inline Functions?

For example In my script I have:

MonthName(Date(Fecha1,'YY-MMM')) as Fecha1,

I have this but QV gives Error:

Report:

Load *, MonthName(Date(Fecha1,'YY-MMM')) as Fecha1;

Load * Inline[

Fecha1, Fecha2

31/01/2011, 30/11/2010

31/01/2011, 31/12/2010

31/01/2011, 31/01/2011

28/02/2011, 31/12/2010

28/02/2011, 31/01/2011

Thank You!

[cesaraccardi · Accepted solution]

Hi,

Do like this:

Report:

Load *, MonthName(Date(Fecha1,'YY-MMM')) as Fecha1_AnoMes

Inline[

Fecha1, Fecha2

31/01/2011, 30/11/2010

31/01/2011, 31/12/2010

31/01/2011, 31/01/2011

28/02/2011, 31/12/2010

28/02/2011, 31/01/2011

Regards,

Cesar Accardi

[MayilVahanan]

Hi

Try this also

Load *,MonthName(Date(Date,'YY-MMM')) as MonthName;

Load *,Date#(Fecha1,'DD/MM/YYYY')as Date Inline

[

Fecha1,Fecha2

31/01/2011,30/11/2010

31/01/2011,31/12/2010

31/01/2011,31/01/2011

28/02/2011,31/12/2010

28/02/2011,31/01/2011

];

[CELAMBARASAN]

Hi,

In your load statement you have used * (asterisk) which is to include all the fields.

Example:

Your inline load has Fecha1,Fecha2 fields.

You are trying to create another field in the name of Fecha1 again along with it.

There should not be more than one with same name. Not alone QV none accepts this.

Hope your clear about the error.