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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

String Method syntax in tMap Expression for Two seperate columns values have to have two distinct values for a seperate column to have a True or False Value

I am wondering how I can nest a if then else statement based off of two seperate values in the two diffrent columns So a diffrent column would have a True or False Value.

This is a typical If then else string method in java

column1.equals("Home Phone")? "True":"False"

If I wanted to add another column with a distinct value would the syntax be

column2.equals("Fax") && column1.equals("Home Phone")? "True":"False"

 

I'm in early development of a job and can't run the job yet, so just making sure the syntax is right from the start.

 

Let me know,

 

Thanks,

 

Andrew

Labels (3)
1 Reply
vapukov
Master II
Master II

Hi 

 

the syntax looks correct, but you always could (and it very useful) make a small test for parts of a big  job

 

it is very complicated to test not a finished job, but nothing easier than creating simple:

  • tFixedFlowInput
  • tMap
  • tLogRow

I have in any project folder tests where located any small tests and ideas what we want to check