load multiple columns data into single column in informatica?

Question

I want to load multiple columns data into single column in informatica.

Answer 1

Use the Expression Transformation to Concatenate all the desired columns and map it with target.

Comments

Thank you shatark sir,
This is input
id  val
1   a
1   b
1   c

I want this out put  
id  val1  val2   val3
1   a       b         c

How to do sir, Please explain sir, I have to know this answer

---

Its better u register, registered people has better chances of answer. And this is very old thread so better to ask fresh query with full detail.

Answer 2

Suppose your source data data is like below:

id val
1  A
1  B
1  C

and your desired output is like :

1 ABC

If I understood your problem correctly, Then use expression and aggregator transaformation. In expression transformation, concat val column with the help of using variable port like below.

id --- I/O port
val -- I/O port
v_prev_id = id  --- Variable port
v_val = iif(v_prev_id = v_curr_id, v_val || val, val)  --- Variable port
v_curr_id = id  --- Variable port
o_val = v_val -- output port

data after expression transformstion would be like below:

id o_val
1   A
1   AB
1   ABC

Take an Aggregarator after expression , and chhose id as group by. and pass id and o_val port to your target. It will give your desired output.

If your data is like (1, A, B, C) and your desired output is (1,ABC) Then what Shatark sir suggested is correct answer.

Comments

Described in the best way.

---

I have one column that consist of 3 rows i.e (ABC). This data splitted to 3 columns
input       output
c1           c1   c2   c3
a             a     b     c
b
c

Please send this answer

---

I think Nandan has described the same.
If you still have some query please ask the separate question as this is very old thread.