Please assist , not linking correctly ?

[suvechha_b]

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');

[kaushiknsolanki]

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