If match statment?

[#1]

Hi guys,

I need to solve this problem and cant get my head around it,

I have a statight table that looks like this. I need a calculation that shows the value 1 if a single SSN has the value smoke and snuff on a matching date. Ive tryed a if match statment like this but cant get i right

if(Match(Signed,SSN, Rökare and Snusare='1', 1) 

SSN	Signed	Smoke	Snuff
565656	2015-07-01 10:38	1	-
565656	2015-07-01 10:38	-	1

Any ideas?

[Anonymous]

can we try like:

if(Signed='1' or SSN='1' or Rökare='1' or Snusare='1', 1)

or depend on what you need

if(Signed='1' and SSN='1' and Rökare='1' and Snusare='1', 1)

[buzzy996]

are u looking for this?

[sunny_talwar]

Not really sure how you data is structured, would you be able to prepare a small sample?

[Mark_Little]

Hi,

Shiva's proposed solution seems to show the correct answer, but as Sunny has suggested a small data set or QVW would help, as I would suggest looking at the data model, I would normally expect the  to see you example as one line.

SSN	Signed	Smoke	Snuff
565656	2015-07-01 10:38	1	1

Then the set analysis would be easy, or even script a flag.

Mark