Unanswered questions

2 Conversations

S
sriram.pasamCommunity Manager
asked in Product Q&A

Syntax error in Continuous query(CQ) to inject NULL value for String field value

I am building a CQ to inject NULL values for String data fields that have “Not available” in the source database.CASE WHEN META(o,"TableName").toString()=="<schema-name>.<table-name>" then CASE WHEN TO_STRING(data[12]) ="Not Available" THEN putUserData(o, 'DENOMINATOR', "NULL") WHEN TO_STRING(data[13]) = "Not Available" THEN putUserData(o, 'SCORE', NULL) WHEN TO_STRING(data[14]) = "Not Available" THEN putUserData(o, 'LOWER_ESTIMATE', NULL) WHEN TO_STRING(data[15]) = "Not Available" THEN putUserData(o, 'HIGHER_ESTIMATE', NULL) ELSE OI am receiving the following compile error : Error Saving ComponentSyntax error at: CASENULL)Please fix the errors and click "Save" again. I also tried the following syntaxCASE WHEN TO_STRING(data[12]) ="Not Available" THEN NULLWHEN TO_STRING(data[13]) = "Not Available" THEN NULLWHEN TO_STRING(data[14]) = "Not Available" THEN NULLWHEN TO_STRING(data[15]) = "Not Available" THEN NULLReference docs : https://www.striim.com/docs/en/handling-null

1
S
1 month ago
J
johnInspiring
asked in Product Q&A

Streaming to kafka topic in confluent cloud

Are there any examples of using Striim’s KafkaWriter to stream data to a topic in Confluent Cloud? 

4
Robert Lauriston
11 months ago

Badge winners

  • Striim Expert
    sriram.pasamhas earned the badge Striim Expert
  • Striim Expert
    igg-mariohas earned the badge Striim Expert
  • Friend of the Community
    Sweta Garaihas earned the badge Friend of the Community
  • Friend of the Community
    Sidhas earned the badge Friend of the Community
  • Streaming Sensei
    Sidhas earned the badge Streaming Sensei
Show all badges
Terms & ConditionsCookie settings