How to use set analysis with if statement?

[mrichman]

Hi Community,

How can I best approach the following issue. I have two fields, which likely have the same values (type1 and type2) and want to count based on customer ID.

Example:

Data:

LOAD * inline [

Customer|Type1|Type2

Astrida|TV|Radio

Astrida|TV|Ref

Astrida|TV|TV

] (delimiter is '|');

In word: only count Customer if Type1 and Type2 have the equal field, and ignore all rows which do not comply with the formula.

Thanks in advance.

[sunny_talwar · Accepted solution]

Look here

How to create Set Analysis in combination with If statement?

[mrichman]

Hi Sunny, thanks. Some lag occured.