Apex Code Development You need to sign in to do that
Don't have an account?
Bob Allen 6 Wave SAQL - Unknown Token
I am attempting to pass a token from q "CurrentWeek_Period" to filter Q_CW and another Q_LW (not provided). Received "unknown Token for "CurrentWeek_Period" so how does one pass filter values from one data strem into another?
q = load "Relative_Salesforce_Lead";
q = filter q by date('CreatedDate_Year', 'CreatedDate_Month', 'CreatedDate_Day') in [dateRange([2017,10,16], [2017,10,16])];
q = group q by 'CreatedDate2.Week_Override';
q = foreach q generate 'CreatedDate2.Week_Override' as 'CurrWeek_Period';
q_CW = load "Relative_Salesforce_Lead";
q_CW = filter q_CW by 'CreatedDate2.Week_Override' == 'CurrWeek_Period';
q = load "Relative_Salesforce_Lead";
q = filter q by date('CreatedDate_Year', 'CreatedDate_Month', 'CreatedDate_Day') in [dateRange([2017,10,16], [2017,10,16])];
q = group q by 'CreatedDate2.Week_Override';
q = foreach q generate 'CreatedDate2.Week_Override' as 'CurrWeek_Period';
q_CW = load "Relative_Salesforce_Lead";
q_CW = filter q_CW by 'CreatedDate2.Week_Override' == 'CurrWeek_Period';