Yes. i implemented the code, but the output did not change. In my case, it does not work.
When I tried using
'="'&[Code]&'"' as [Code]
it gives me the leading 0's but the other fields do not display correctly.
I am trying to get a csv file as output. My code is below:
[SGroup]:
LOAD
[A Code],
[Dep Year] as [Travel Year],
[Book Date] as [G Booking Date],
GuFlag as GFlag,
[Group] as [G Group],
[G Total Price] as [Total Price]
Resident [Creator]
Where GuFlag='Y' and match(left([A Code],1),'0', '1', '2');
left Join ([SGroup])
LOAD
[A Code],
[G Group Name] as [GroupNme]
Resident Light;
//Output Calculation By Group
Let vCurrYear=Year(Today()); //2016
[OutpuGGroup(2015 and 2016)] :
LOAD
[A Code],
[GroupNme] as [GroupName],
[G Group] as [GGroup] ,
[A Code]&'-'&[GroupNme]&'-'&[G Group] as Key,
sum([Total Price]) as [CYBookingR]
Resident [SGroup]
WHERE [Travel Year] = $(vCurrYear) //2016
Group By [A Code],[GroupNme],[G Group];
Let vCurrYear=($(vCurrYear)-1); //2015
Join ([OutpuGGroup(2015 and 2016)])
Load [A Code],
[GroupNme] as [GroupName],
[G Group] as [GGroup] ,
[A Code]&'-'&[GroupNme]&'-'&[G Group] as Key,
sum([Total Price]) as [PYBookingR]
Resident [SGroup]
WHERE [Travel Year] = $(vCurrYear) //2015
Group By [A Code],[GroupNme],[G Group];
Gout:
Load //'="'&[A Code]&'"' as [A Code],
[A Code],
//'="'&[GroupName]&'"' as [GroupName],
[GroupName],
//="'&[GGroup]&'"' as [GGroup],
[GGroup],
//'="'&Key&'"' as Key,
Key,
if(IsNull([PYBookingR]),0,[PYBookingR]) as [B.PYBooking R],
if(IsNull([CYBookingR]),0,[CYBookingR]) as [B.CYBooking R]
Resident [OutpuGGroup(2015 and 2016)] ;
left join
Load //'="'&[A Code]&'"' as [A Code],
[A Code],
//'="'&[GroupName]&'"' as [GroupName],
[GroupName],
//="'&[GGroup]&'"' as [GGroup],
[GGroup],
//'="'&Key&'"' as Key,
Key,
num(if([B.PYBooking R]= 0 and [B.CYBooking R]=0,0,
if([B.PYBooking R]<> 0, [B.CYBooking R]/[B.PYBooking R]-1, 1.00)),'#,##0.00') as [B.YOY R]
Resident Gout ;
Drop Table [OutpuGGroup(2015 and 2016)];
Drop field Key from Gout;
//Store '="'&[A Code]&'"' as [A Code],
Store [A Code],
[GroupName],
[GGroup],
[B.PYBooking R] as [PYBooking R],
[B.CYBooking R] as [CYBooking R]
//Store *
From Gout
INTO [$(vOutfile2016)](txt);
Drop Table Gout;
Drop Table [SGroup];
