4 Replies Latest reply: May 26, 2016 2:59 PM by Harinder Bakhshi RSS

    If statement in Load

    Harinder Bakhshi

      Hi,

       

      I'm trying to get this line to work in a load statement for a new table.

       

      PerformanceData:

        Load

        [TestId],

        IF ([Site Type] ='ICMP', ([Mean Frame Loss]*2) AS [Mean Packet Loss], [Mean Frame Loss] AS [Mean Packet Loss])

        Resident [TestData]


      The fields are in two tables:

       

          Site:

          Load

          [TestId]

          [Site Type],

          FROM [Combo.qvd] (QVD)

          ;

       

       

        TestData:

        Load

        [TestId],

        [Mean Frame Loss],

        FROM [Combo.qvd] (QVD)

          ;

       

      So if the Site Type is ICMP, then the Mean Frame Loss should be doubled and put into the Mean Packet Loss Field, otherwise the Mean Frame loss should be put into the Mean packet loss field unchanged.