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.  How to remove 2 columns from a BRD

    Employee
    Posted 05-08-2018 03:22

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

    Originally posted by: JohnPD

    Hello everyone,

    I would highly appreciate if anyone could help me out with the following challenge in Lavastorm.

    I want to remove 2 columns which are in the output of the BRD files, before entering the multiple BRD files node (core).
    The output of the BRD files consists of two BRD files, from which one of them has 2 extra columns and that's what causing this error.

    I'm wondering if these is a node available which deletes two columns in a BRD file, before entering the multiple BRD files node.

    NeedHelp.png

    Unfortunately I can't change the input of the BRD files, because that would have solved everything, so I'm hoping that there is a node which can do this.

    Thank you guys!

    Cheers,


  • 2.  RE: How to remove 2 columns from a BRD

    Employee
    Posted 05-08-2018 03:53

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

    Originally posted by: awilliams1024

    Hi,
    you should be able to use the 'ConcatenationMode' property of the Multiple BRD Files node to read in the data from the BRD files (see the Optional tab).
    By default, the node uses the 'exact' mode. If you want to strip off the two extraneous fields then set the property to 'intersection'.
    Alternatively, you can set the property to 'union' which will import all the fields from each of the BRD files, inserting Null values for fields that do not exist in any particular BRD file.


  • 3.  RE: How to remove 2 columns from a BRD

    Employee
    Posted 05-08-2018 04:12

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

    Originally posted by: JohnPD

    Hi Awilliams1024,

    You're absolutely right, it works!
    Thanks a lot mate.

    Cheers