Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

Case 836 How to link my SOURCE filed with SOURCE_ ?

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 )

CANNOT DISPLAY SALES.png

My data model as below :-

SOURCE FILED.png

Paul

 

0 Replies