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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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