Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Excel Input: how to know no of columns having data

  1. #1
    Join Date
    Jul 2008
    Posts
    26

    Question Excel Input: how to know no of columns having data

    Hi Friends,

    I am working in transformation where i m reading from an excel input.

    I want to know how many no of columns are coming in with data is there any way or any variable to know it.

    Can i do it in next step using java script?

    thanks
    Novin

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Well.. you know the maximum number of columns having data ... as you have to enter the columns you will read.

    You can filter per row whether a certain column has a value, but there are no "column operators"

    Regards,
    Sven

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.