Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what are the naming convection's
1) table name
2) qvd name
3) variable
4) flag
5) ipc nameing
one more that
5) Reduce columns: find unused fields in that data model use documnetanalyzer.qvw against your app to do this , and then copy the drop fields statements that are generated for the unused fields and place these into a new tab in application , as the last tab in the script.
May it help you
This is just an prefix for a field and we can define at our own way. Here is some common use in script:
Variables | Starts with a "v" e.g. vCurrentYear |
Key Fields | Starts with a "%" e.g. %CustomerKey |
Flag Fields | Starts with a "_" e.g. _YTDFlag |
Cycle Group | Starts with a "<" e.g. <ProductCycle |
Drilldown Group | Starts with a ">" e.g. >GeoDrillDown |
Key Field Separator Separated by "_" e.g. Company&'_'&Nbr as Key
Temp Fileds/Tables End With "_tmp" | e.g. Daily_Trans_tmp |
By the way, is use those prefix to hide a field while we load data. Something like Set HidePrefix='_' ;
I'm not sure what the question about the documentanalyzer is, but it is better to never load unused fields instead of dropping them at the end of the script. You'll save time and RAM. (Qlikview Notes: DROP FIELD Does Not Release All Space)
Karl