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
Answer / enu
Another method we can also use interleave component which gathers data in round robin.
Is This Answer Correct ? | 1 Yes | 0 No |
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 |
Answer / apoorva
We can use Partition by round robin component with block size 1.
Is This Answer Correct ? | 1 Yes | 1 No |
What is the purpose of having stored procedures in a database?
What is sandbox?
Code check-in and check-out commands in AbInitio
What is the difference between In-Memory Sort and Inputs must be sorted?
What is meant by Co > Operating system and why it is special for Ab-initio ?
How many components in your most complicated graph?
What is the significance of record required indicator of Join component ?
Difference between public and private projects and how to make private to public?
How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa
Describe the Evaluation of Parameters order.
What is the DynamicScriptGeneration and what is the Use?
What is regex (lookup)? When you should use it? How to use in abinitio graph?