About Umesh

I am Software consultant with approx 7 years of experience mainly in Business Intelligence and data warehousing assignments using Talend. Writing is not my passion but i am doing it to help others. if you have any special case where you want me to demonstrate then please post me.

3 comments on “How to Add Header and Footer to a File

  1. Hi umesh,
    thank you for sharing this useful information which really helpful to beginners.
    please also provide solution for Oracle Bigdecimal number(talend takes it by default while fetching data from DB) problem as we cant compare it with integer.

    1. Hi Indrajit,

      Thank you for posting comment.

    2. if you are facing problem with conversion of BigDecimal to Integer then change the data type at input component.
    3. Or you can convert BigDecimal value to String first then use Integer.valueOf() function to convert string value to integer make sure you are checking for nullablity other wise it raise for error
    4. second type of conversion only works if you it has no scale associated with BigDecimal.
      I will write detail article on numeric conversions but you can try something like.
      `Integer.valueOf(bdValue.intValue()) // if you have values like 1000 and not more than size of integer.`

      if you don“t care about scale then use blow function it will work.

      `bdValue.setScale(0,BigDecimal.ROUND_DOWN).intValueExact(); // value=100.23 result=100`

  2. This example is not working, context Create context variable named as “NumberOfRows”

    i am not getting the count of no of rows

Leave a Reply to Sushant Cancel reply

Your email address will not be published. Required fields are marked *