Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Excluding columns from output

  1. #11

    Default

    Hi Mullin,

    Thanks for your suggestion. I've given the sample data for department wise but I want to read only the required columns from the excel file based on the input parameter (month). It will not be consistent as there are chances that month data will not be available.

    I need only the first 5 columns from the excel if the input parameter value is Jan.

    Here is the actual file,

    Sum of Jan Balance Sum of Feb Balance Sum of Mar Balance
    Col1 Col2 Col3 Incoming Outgoing Incoming Outgoing Incoming Outgoing
    1022 1123357 Test1 9,169.49 0.00 9,370.47 0.00 9,370.47 0.00
    1022 11234341 Test2 1.14 0.00 0.49 0.00 0.49 0.00

    Thanks,
    ArSample_data.jpg

  2. #12

    Default

    Quote Originally Posted by Arunn View Post
    Hi Mullin,

    Thanks for your suggestion. I've given the sample data for department wise but I want to read only the required columns from the excel file based on the input parameter (month). It will not be consistent as there are chances that month data will not be available.

    I need only the first 5 columns from the excel if the input parameter value is Jan.

    Here is the actual file,

    Sum of Jan Balance Sum of Feb Balance Sum of Mar Balance
    Col1 Col2 Col3 Incoming Outgoing Incoming Outgoing Incoming Outgoing
    1022 1123357 Test1 9,169.49 0.00 9,370.47 0.00 9,370.47 0.00
    1022 11234341 Test2 1.14 0.00 0.49 0.00 0.49 0.00

    Thanks,
    ArSample_data.jpg
    Hi,

    Can someone please help me to read the above file ?

    Thanks

  3. #13
    Lavastorm Employee gmullin's Avatar
    Join Date
    May 2014
    Location
    Chicago
    Posts
    185

    Default

    Attached is a couple of different ways using the data you found. There's always multiple ways to get the result you want, with these examples you should be able to work out how to cater for the data as you are expecting to receive it.

    Months.jpg
    MonthsExcel.brg

Similar Threads

  1. Replies: 5
    Last Post: 02-16-2012, 12:32 AM
  2. Excluding fields by Wildcard and Pattern
    By ltolleson in forum Nodes
    Replies: 4
    Last Post: 02-18-2010, 03:12 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •