Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to pass a String correctly

hi

how can i pass String in active express Builder ?

am doing like this

 

0683p000009LsNg.jpg

 

am not getting any output.

 

Labels (1)
25 Replies
TRF
Champion II
Champion II

I suppose there is no filter on the input side.

So, maybe a non editable character into your database field value (?)

Just for testing, can you replace the expression by the following (to ignore the last character):

row1.DeviceId.startsWith("LAB0115AN3131")
Anonymous
Not applicable
Author

am not getting any row in my database.when am using row1.DeviceID.startsWith("LAB1216AN3012")

am also try row1.DeviceID.contains("LAB1216AN3012"). my output database is empty.

when i will use only mapping not any condition than am getting output.

please kindly help me. 

 

Anonymous
Not applicable
Author

where is my fault ? if there is another way please suggest me.

 

manodwhb
Champion II
Champion II

can you check your data,is it have in UPPER case or LOWER case values?

if you have lowercase use ignore case or StringHandling.UPCASE functions.

 

 

LAB1216AN3012 or lab1216an3012

TRF
Champion II
Champion II

Strange.

Replace your database by a file and remove the tMap expression filter then search for the value in the file using your prefered text editor to check that your data arrive as expected.

Anonymous
Not applicable
Author

uppercase or lowercase  no issue.

manodwhb
Champion II
Champion II

no issue means is your issue fixed?

Anonymous
Not applicable
Author

lower case and upper case is not issue. my problem is not fixed now.

am also trying different approach due to it am not responding instant. 

when my problem is fixed i will Accept as Solution because i don't want my problem became anybody headache.

Anonymous
Not applicable
Author

Dear Folks

Please provide me solution related my post. 

Anonymous
Not applicable
Author

Can you try 

(row1.DeviceId).equals("LAB0115ANS3131 ")  ?

with braces around the variable.