Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
How can I bring the record_source_gm_id as 27 ?
See the script only '27' values are present , then why the record_source_gm_id is coming null ? sample model attached.
[BORD]:
LOAD
//RECORD_SOURCE_GM_ID&'|'&CLAIM_NUMBER as "KEY",
"RB_CALENDAR_PERIOD" as "Import Month",
"RECORD_SOURCE_GM_ID",
"CLAIM_NUMBER",
"GROSS_CLAIMS_PAID" as "EDW Amount";
SQL SELECT
[RB_CALENDAR_PERIOD]
,[RECORD_SOURCE_GM_ID]
,[CLAIM_NUMBER]
,[GROSS_CLAIMS_PAID]
FROM [DWUQV_CLAIM_PAYMENT_TRANSACTION] where [RB_CALENDAR_PERIOD] ='2019-01-01'
and RECORD_SOURCE_GM_ID in ('27');
Hi,
It seems your SQL is not understanding the AND function.
Try enclosing the condition in Brackets, like below.
FROM [DWUQV_CLAIM_PAYMENT_TRANSACTION] where ([RB_CALENDAR_PERIOD] ='2019-01-01'
and RECORD_SOURCE_GM_ID in ('27'));
Or consult your database admin.
Regards,
Kaushik Solanki