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