i have 2 files. First file contains a,b,c,d as rows and second file contains 1,2,3,4 as rows. how do we make single a1b2c3d4 and 4 different rows a1, b2, c3,d4.

Answers were Sorted based on User's Feedback



i have 2 files. First file contains a,b,c,d as rows and second file contains 1,2,3,4 as rows. how do..

Answer / krishna

we can use fuse component

Is This Answer Correct ?    6 Yes 1 No

i have 2 files. First file contains a,b,c,d as rows and second file contains 1,2,3,4 as rows. how do..

Answer / enu

Another method we can also use interleave component which gathers data in round robin.

Is This Answer Correct ?    1 Yes 0 No

i have 2 files. First file contains a,b,c,d as rows and second file contains 1,2,3,4 as rows. how do..

Answer / jatin chawla

1. Use fuse component to join two files and will give output
col1 col2
a 1
b 2
c 3
d 4

Then in Reformat do out.col :: string_concat (col1,col2)

Is This Answer Correct ?    2 Yes 1 No

i have 2 files. First file contains a,b,c,d as rows and second file contains 1,2,3,4 as rows. how do..

Answer / apoorva

We can use Partition by round robin component with block size 1.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Ab Initio Interview Questions

What is the purpose of having stored procedures in a database?

0 Answers  


What is sandbox?

0 Answers  


Code check-in and check-out commands in AbInitio

0 Answers  


What is the difference between In-Memory Sort and Inputs must be sorted?

3 Answers  


What is meant by Co > Operating system and why it is special for Ab-initio ?

2 Answers  






How many components in your most complicated graph?

0 Answers  


What is the significance of record required indicator of Join component ?

1 Answers   HCL,


Difference between public and private projects and how to make private to public?

1 Answers  


How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa

0 Answers  


Describe the Evaluation of Parameters order.

1 Answers  


What is the DynamicScriptGeneration and what is the Use?

2 Answers  


What is regex (lookup)? When you should use it? How to use in abinitio graph?

1 Answers   Steria, Wipro,


Categories