Search code examples
datastage

How to get the count of an Excel in unix or Linux in datastage


Is there any possibility i can get the count of an excel in unix or linux.

I tried creating server routine & i am able to get the output link count but i am unable to get return value into a file or variable.

Please suggest,


Solution

  • There are lots of information (besides the data itself) that can be extracted from an Excel file - check out the documentation

    I could imageine two options for your goal:

    • check a certain cell which would be filled/exist if the file is not empty

    • check the filesize of an empty file and if the filesize is bigger than that it is not empty