Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Sunny, thanks. Some lag occured.