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.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between rollup and scan?

1504


Describe in detail about lookup?

823


What is a look-up?

844


Within a cursor, how would you update fields on the row just fetched?

822


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

841


Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?

761


How scientific data processing is different from commercial data processing?

821


What is the difference between formal and export parameter? Export at what secenario we are going to use?

2365


What exactly do you understand with the term data processing and businesses can trust this approach?

842


Can anyone give me an exaple of realtime start script in the graph?

771


What is m_dump?

948


Code check-in and check-out commands in AbInitio

3875


Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio

1293


How can you export a component’s internal parameters ?

2112


We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?

1130