How to load the data from an excel sheet to input file in a
graph?

Answer Posted / guillermo villarreal

You can save the spreadsheet as *.csv then write the data
layout as comma delimeters. You may skip the first record
which may have all header column names.

Is This Answer Correct ?    14 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why creation of temporary files depends on the value of MAX CORE ? How to use in abinitio graph? 10. What is the diff between abinitiorc and .abinitiorc files ? How to use in abinitio graph? 11. What is the use of allocate()? How to use in abinitio graph? 12. What is use of branch in EME ? 13. How you can break a lock in EME ? How can you lock a file so that only no one other than EME admin can break it ? How to use in abinitio graph? 14. When you should be using ablocal() ? How you can use ablocal_expr? How to use in abinitio graph? 15. Why you should not keep the layout as 'default' for input table component ? How to use in abinitio graph? 16. What is dynamic lookup ? How to use in abinitio graph? 17. What is dependent parameter ? How to use in abinitio graph? 18. What is BRE ? (Business Rule Environment - This is a recent addition in abinitio package) How to use in abinitio graph? 19.What is output index ? How to use in abinitio graph? 20. How you can track the records those are not getting selected from ‘select’ in reformat component ? How to use in abinitio graph? 21. Can we have more than one launcher process for a particular graph ? How about agent ? How to use in abinitio graph? 22. There are lot of new fuctions added in 2.15 , you can ask about them ? How to use in abinitio graph? 23. How can you run multiple instances of a graph in parallel? How to use

3562


How to create a repository in abinitio for stand-alone system(local nt)?

641


What is a data processing cycle and what is its significance?

670


List out some of the air commands used in abintio?

734


Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?

546






Difference between informatica vs ab initio?

727


What kind of layouts does abinitio support?

641


Explain the difference between the truncate and delete commands?

628


How to replace last 4 digits of an input column with XXXX given input column has 12 digits?

625


What are the Graph parameter?

704


What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?

720


What is sort component in abinitio?

714


Do you think effective communication is necessary for data processing? What is your strength in terms of same?

669


Define ramp limit in ab initio?

791


State the working process of decimal_strip function?

1577