Skip to Content
0
Former Member
Dec 08, 2006 at 09:41 AM

How to do this mapping in XI

20 Views

hi,

My Source Structure is like

Object_IND FILENAME FILEVALUE

0 Column1 aaa0

0 Column2 bbb0

0 Coulmn3 ccc0

0 Coulmn4 ddd0

0 Coulmn5 eee0

1 Column1 aaa1

1 Column2 bbb1

1 Coulmn3 ccc1

1 Coulmn4 ddd1

1 Coulmn5 eee1

2 Column1 aaa2

2 Column2 bbb2

2 Coulmn3 ccc2

2 Coulmn4 ddd2

2 Coulmn5 eee2

Basically there is a group of five records for a particula object index

I have to display in file values for coulmn1 and column3 only

ie my output file should like

aa0,cc0

aa1,cc1

aa2.cc2

Can we do via value mapping , or is there a simpler way to do .

If any one of you have does , please do revert back

Thanks

Amit