Cross over table with Flags

[paullawrence190]

Hi

I want to take some data in a cross over table and put some flags on it.   The flags work fine when not crossover but fail when I convert to crossover.  Is there any ay to make this work please.  Data is coming form a spread sheet that is fed out of Sage so I cant alter it easily.

Thanks

Paul

Simple table:

LOAD
Client,
Code,
Jan,
Feb,
Mar,
Apr,
May,
June,
if(WildMatch([Code],'*1001*') and WildMatch([Code],'*Revenue*'),1,0)  as MSKTriageFLag

Cross:

CrossTable(Date, Data, 2)
LOAD Client,
Code,
Jan,
Feb,
Mar,
Apr,
May,
June,

if(WildMatch([Code],'*1001*') and WildMatch(

,'*Revenue*'),1,0)  as MSKTriageFLag

[Frank_Hartmann]

try like this:

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='#.##0,00 €;-#.##0,00 €';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD.MM.YYYY';

SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';

SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';

SET DayNames='Mo;Di;Mi;Do;Fr;Sa;So';

1:

LOAD Client,

     Code,

     Jan,

     Feb,

     Mar,

     Apr,

     May,

     June

FROM

[227208.xlsx]

(ooxml, embedded labels, table is Tabelle1);

2:

CrossTable(Date, Data, 2)

LOAD Client,

     Code,

     Jan,

     Feb,

     Mar,   

     Apr,

     May,

     June

FROM

[227208.xlsx]

(ooxml, embedded labels, table is Tabelle1);

Load *,

if(WildMatch(Code,'*1001*'),1,if( WildMatch(Code,'*Revenue*'),1,0))  as MSKTriageFLag

Resident 2;

DROP Table 2,1;

[MarcoWedel]

maybe like

CrossTable(Date, Data, 3)
LOAD Client,
Code,

if(WildMatch([Code],'*1001*') and WildMatch(

,'*Revenue*'),1,0)  as MSKTriageFLag,

Jan,
Feb,
Mar,
Apr,
May,
June

hope this helps

regards

Marco

[vinieme12]

Do a cross tab of your resident simple table

TAB_SIMPLE:

LOAD
Client,
Code,
Jan,
Feb,
Mar,
Apr,
May,
June,
if(WildMatch([Code],'*1001*') and WildMatch(

,'*Revenue*'),1,0)  as MSKTriageFLag

Cross:

CrossTable(Date, Data, 3)
LOAD Client,
Code,

MSKTriageFLag,

Jan,
Feb,
Mar,
Apr,
May,
June

RESIDENT TAB_SIMPLE;

Drop Table TAB_SIMPLE;

[paullawrence190]

Thanks this is perfect I thought it was going to need a Resident table but was not sure how to do it.

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).

If not, please make clear what part of this topic you still need help with .