Hi All
I have a field NAME_PNL was created using partial load.
left keep (GL_TABLE)
load [Reporting Code], GL_DESC,
if(num([Reporting Code])<'12','1 REVENUE',
if(num([Reporting Code])<'35','2 COGS',
if(num([Reporting Code]) < '57','3 OTH INCOME'
))) as [NAME_PNL]
resident GL_TABLE;
I notice that my main table have a field = SOURC_GL , when i change from TDSID to TDSKL , the link between main table with NAME_PNL will automatic not link.
This is because NAME_PNL field is using left keep , and it does not link with my GL_TABLE.
Can some one share with me how to prevent the link drop ? I mean if user change the SOURCE_GL from TDSID to TDSKL it will not affect field NAME_PNL = 1 REVENUE will still turn on.
Paul