1.06-03 Avoid single item subsets

rob_marshall

If possible, try and avoid single item subsets, if there is a top level in the list, a single item subset will always have two members. Consider using a Boolean flag in a SYS module or a LOOKUP line item against the desired item (to avoid using SELECT)

Misbah

Rule 1.06-03: Avoid single item subsets If possible, try and avoid single item subsets, if there is a top level in the list, a single item subset will always have two members

Here is how it was done in Pre Planual Era. We used to create a subset which includes/houses just a single list item

List:

Input module:

Output module:

What is wrong with this method? Item which was supposed to be just one has become two because it will have top level coming along with it.

Here is how it should be done in Planual Way: Can be done in many ways. One way could be with the help of LOOKUP module. Get rid of the subset dimension and use LOOKUP on the ssAsia or Region formatted line item

Output Module

LOOKUP module: