Case 836 How to link my SOURCE filed with SOURCE_ ?

[paulyeo11]

Hi All

I am using FOR to load the sales data , it load by file name.
For Each i in '$(vFile2000)','$(vFile2001)','$(vFile2002)','$(vFile2003)','$(vFile2004)'

From the field name SOURCE i recode THE File name to SOURCE field :-
For example SOURCE_ Field name = SO_PM.CSV SOURCE = PM
For example SOURCE_ Field name = SO_LE.CSV SOURCE = LE

Concatenate
MAP:
load SOURCE_,
if (SOURCE_='SO_PM.CSV','PM',
if (SOURCE_='SO_LE.CSV','LE',
))) as [SOURCE]
resident MAP;

My issue is :-

from SOURCE_ , I Can get sales amount and target amount.

My Question is how to make it , SOURCE , I Can get sales and target amount ? ( Now cannot get target amount )

My data model as below :-

Paul