ItemSkip TM1 Function: Use and Syntax

ITEMSKUP is a Turbo Integrator function that forces the current record being read from a data source to be skipped.

Syntax of ITEMSKIP

The syntax is just ITEMSKIP; – real simple eh! And there are no operators.

Usage

Typically ITEMSKIP will be used with an IF statement so that only data that satisfies a certain criteria will be further processed. This both speeds up the processing and also allows you to discretely set a variable within an IF statement.

For example:

IF ( vChannel @= ‘Grocery’);

vChannelCode = ‘GR’

ELSE;

ITEMSKIP;

ENDIF;

This would test the variable vChannel to see if it contained the word ‘Grocery’ and if so, then set the variable vChannelCode to ‘GR’ and if not, then skip the record (meaning that only Grocery data will end up being processed by this TI.

If you like this post, please spread the love…

About John

Managing Director of Infocube. We are a management accounting consultancy that specialises in Business Analytics.

One comment on “ItemSkip TM1 Function: Use and Syntax

This site uses Akismet to reduce spam. Learn how your comment data is processed.

/* THIS WAS THE CODE USED FOR EMBEDDING A SURVEYMONKEY POPUP */