LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Excel File Node - Specific Columns

    Employee
    Posted 01-13-2017 03:50

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: martinh1976

    Hello - Is it possible to just select certain columns from an excel sheet to read in rather than bring them all through? I have multiple columns which have the same description and its causing an error.

    I am running BRE 4.5 so dont have an option to deal with duplicate column names currently.

    Is there an alternative solution out there?

    Thanks

    Martin


  • 2.  RE: Excel File Node - Specific Columns

    Employee
    Posted 01-13-2017 08:51

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: stonysmith

    I can't open 4.5 at the moment.. but in 5.1+ there is an option "DuplicateFieldNameAction" that you would set to "AutoName"

    Beyond that, if you have a duplicate column name in a data stream.. you can do this


    emit *
    rename '1:13' as MyNewName

    The "13" here needs to be whatever column number that has a duplicate name.


  • 3.  RE: Excel File Node - Specific Columns

    Employee
    Posted 02-09-2017 09:28

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: martinh1976

    Thanks - i arranged an upgrade to v6.1 and its working sweet.

    Cheers

    Martin