Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
What i mean here ,am trying to create different tabs in the edit script for easy understanding. its creating ,but after reloading the same, the new created tab is vanishing and the script part is merged in the first tab sript as commented.
I dont know where am missing.
Is this some error or am doing some wrong.
For example i have posted my script here
///$tab Calculation
load *, if(wildmatch(DATA_STREAM_NAME, 'PSL_On_Time'),MEASURESVALUE ) as PSL_On_Time,
if(wildmatch(DATA_STREAM_NAME, 'PSL_Total'),MEASURESVALUE ) as PSL_TOTAL
;
sql select * from (
select m.data_stream_num,m.data_stream_name,c.customer_num,c.date_num,c.location_num,
c.product_num, c.value as MeasuresValue
from test_adr_measures m, test_adr_act_cdlp c
where m.data_stream_num = c.data_stream_num) ;
///$tab Main 2
load *, if(wildmatch(DATA_STREAM_NAME, 'PSL_On_Time'),MEASURESVALUE ) as PSL_On_Time,
if(wildmatch(DATA_STREAM_NAME, 'PSL_Total'),MEASURESVALUE ) as PSL_TOTAL
;
sql select * from (
select m.data_stream_num,m.data_stream_name,c.customer_num,c.date_num,c.location_num,
c.product_num, c.value as MeasuresValue
from test_adr_measures m, test_adr_act_cdlp c
where m.data_stream_num = c.data_stream_num) ;
here I had created the tab calculation but it came as commented after the reload.
Please provide me the solution for the same.
Its urgent please.
Thanks,
Mahasweta
I believe this can easily happen if you have a /* somewhere with no matching */. Comment blocks like this are across tabs, but the tab definition itself appears to be an interpreted part of the script, so when you comment a block that crosses tabs, it also removes the tabs. You can see this in the "///$tab Main 2". I believe that's the tab definition.