to add a field to existing table

[csairam367]

could you implement in qlikview through this query

SELECT COUNT(*)

              INTO V_PROVISIONING_CNT

              FROM VSNL_INT_POS_STATUS_UPDATES VI

             WHERE VI.ATTRIBUTE2 = P_SERVICE_ID

               AND VI.OBJECT_ID = V_OPPORTUNITY_ID

               AND VI.STAGE_NAME = 'COLLSHF';

            IF V_PROVISIONING_CNT <> 0 THEN

              V_ORDER_STATUS := 'Provisioned';

            ELSE

              V_ORDER_STATUS := 'Under Provisioning';

            END IF;

          END IF;

        EXCEPTION

          WHEN OTHERS THEN

            V_ORDER_STATUS := 'Under Provisioning';

        END;

[jyothish8807]

Hi  Csairam,

May be like this:

Load *,

 IF( V_PROVISIONING_CNT <> 0,'Provisioned','Under Provisioning') as   V_ORDER_STATUS;

SQL SELECT COUNT(*)

              INTO V_PROVISIONING_CNT

              FROM VSNL_INT_POS_STATUS_UPDATES VI

             WHERE VI.ATTRIBUTE2 = P_SERVICE_ID

               AND VI.OBJECT_ID = V_OPPORTUNITY_ID

               AND VI.STAGE_NAME = 'COLLSHF';

[csairam367]

based on this query table is joined with another table.and order status field is not in our table

[csairam367]

thanks for replying my query

[jyothish8807]

Yes,  V_ORDER_STATUS will be a new filed created based on the if condition.