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 / 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 ?    3 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 / 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

Describe the evaluation of parameters order in ab initio?

0 Answers  


Broadcast and replicate does the similar work , what’s the diff then

4 Answers   TCL, Wipro,


Hi friends, what are the new features in abinito3.0?

0 Answers   CTS, TCS,


I have $AI-SERIAL/DML------> (SERIAL FILE LOCATION) AND $BDS-SERIAL/DML---------->(what is the location what is mean)?

1 Answers  


What will be the output of using partition by Round-Robin after the partiton by key in ab initio?

1 Answers  


What is the difference between rollup and scan?

0 Answers  


what is extension list in abinitio?

1 Answers  


Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?

0 Answers  


What are differences between different versions of co-op?

0 Answers  


Code check-in and check-out commands in AbInitio

0 Answers  


What is the purpose of having stored procedures in a data-based?

0 Answers  


How can you find the 2nd Highest salary in a file department wise in abinitio?

9 Answers   IBM, TCS,


Categories