Post reply

How to write Expression on Derived Column

  • June 6, 2018 at 10:11 am

    #406589

    Hi,
    I importing File data using Flat File source with the Below Columns and I need to generate a new column with another File Name.

    I Need to generate a new File with the Below Out Put Like Below:

    Thanks

  • June 6, 2018 at 10:23 am

    #1993112

    Use a Conditional SSIS Expression to do this.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • June 6, 2018 at 4:59 pm

    #1993159

    I tried below expression.

    But it's not working.

    While Importing data from Input file to the derived column , if input file contain any empty value it's not working.

    ISNULL([[Price] ]) ? [Salary] * [Percentage] / 100 : [[Salary] * [Price] / 100] 

    Thanks,

  • June 7, 2018 at 5:21 am

    #1993188

    suresh0534 - Wednesday, June 6, 2018 4:59 PM

    I tried below expression.

    But it's not working.

    While Importing data from Input file to the derived column , if input file contain any empty value it's not working.

    ISNULL([[Price] ]) ? [Salary] * [Percentage] / 100 : [[Salary] * [Price] / 100] 

    Thanks,

    OK, try refining that as follows:

    ISNULL([[Price] ]) || [Price] == "" ? [Salary] * [Percentage] / 100 : [[Salary] * [Price] / 100] 

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply