Mapping of 2 source tables to 1 target table field

[Former Member]

Hello,

I need to add two fields of source from different tables to one target table of one field.

EX:

My target is infotype0105

common type        sysID

         

1                                        cell

5                         info@gmail.com                    Email

20                         01263645665                    Fax

I need target like above. But in my source Email field is on table and phone number is another table.

Can any one help to solve this problem

Regards

Rama

[Former Member]

Use the SQL transform and bring the source data as it is.

Then use the pivot transform by keeping ID column as Non-Pivot column and Email,Phone columns as pivot column.

Source one:

Source two:

Pivot transform:

Target table :

[Former Member]

That pivot is totally unneccessary, just use Merge transform as previously suggested.

[ahalya_inturi]

hi Rama,

i think u wanted to do merge data from two different tables as you having two sources

make the two source schema field names as same including data type in 2 different query transformations

take the merge transformation connect two query transformation to merge transformation

try this , may it help u

[vnovozhilov]

Hi Rama,

I am not sure if it is only me, but I can't see the pictures. Could you please modify your post and make it readible to make your intentions clear.

So far, I assume that concatenation could do the trick but I am not sure if I understood your problem.

Thank you,

Viacheslav.

[Former Member]

Hi Viacheslav,

My problem is i need display table of one field but source tables are 2. i am have map 2 source fields from different table to one target table field.

Regards

Rama