Jump to content

Concat with multiple ifs


mjahkoh

Recommended Posts

How would i construct a concat as below

 

concat (fielda,fieldb  ,    if (fieldz=1,'cat','dog'),  if(fieldy=1,'dog','mouse') )

 

the concat is ok without the ifs and appends the result of evaluating

if (fieldz=1,'cat','dog') and  if(fieldy=1,'dog','mouse') ) to fielda and fieldb

 

Thanks in advance

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.