Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I am hoping that someone can help with my question here. Basically I have a test that calculates employees that have >20% cash to expense ratio from an employee table. THis table also has a date. Loading all the data works fine for the test but when selecting a specific date ( for example, Aug 2013) it does not update. It still is in reference to the entire data population. How do I make sure that the result updates for only the specified date selected?
Test:
MAPPING LOAD
Concur_Emp_ID
,IF(Sum_Cash_Emp/Sum_All_Emp >= .2 ,'Yes','No')
RESIDENT TE_Date;
Thank You!
I'm not sure I understand your question. Are you perhaps looking for a where clause?
MAPPING LOAD
Concur_Emp_ID
,IF(Sum_Cash_Emp/Sum_All_Emp >= .2 ,'Yes','No')
RESIDENT TE_Date
WHERE MyDate = ..... ;