how to handle empty string like coliumns=" " i want to insert mysqldb incolumn int type empty string means as Null but it shows error .

30-Day Free Trial: It’s Never Been Easier To Get Started With StreamSets

1 year ago

Home
Community overview
StreamSets Platform
Community Articles and Got a Question?
how to handle empty string like coliumns=" " i want to insert mysqldb incolumn int type empty string means as Null but it shows error .

below is my error

I want to write these type columns (columns=””)to NULL IN mysqldb

Page 1 / 1

@deepikamani007

can you please try to use the below code in expression evaluator and check if it works for you.

${str:isNullOrEmpty(record:value("/emailid"))?NULL:record:value("/emailid")}

Thanks & Regards

Bikram_

The StreamSets Community has your back.

Sign up

Already have an account? Login

Username *

E-mail address *

What I do... *

Data Leader Data Architect Data Engineer Data Scientist Other

Company *

Country *

Zip Code *

Marketing Communications

Yes No

Password *

I have read and Agree to the Website Terms of Service and I have read and acknowledged the Privacy Policy.

loginBox.register.email_repeat

Username or Email

Password

Remember me

Forgot password?

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

Sorry, our virus scanner detected that this file isn't safe to download.