Creating a field

Please see attached file for visual demonstration.

I have two files:

1. has keycodes for my campaign with customers who received the campaign

2. has purchases that were between certain time period (these include people who may or many not be in the campaign file)

I joined these two. I got the joins and it's all good. BUT now I want to do some predictive analytics on this. To do that I need to have binary field 'yes' or 'no' to determine if someone made a purchase or not and that is based on 'this customer was sent an email and he/she made a purchase so say 'yes' or vice-versa'.

I thought that I could create a field in the workflow that says 'yes' or 'no' rather than taking the files into excel and then doing the manual additional of a colum etc. etc. for all these files.

Is it possible to do what I am asking for or do I need to take the files into excel and then add the response?

Is this clear or should I give more information?

Thank you

Aman

question.docx

Best Practices

Join

Preparation

Accepted answers

akaur

Thank you all. It all worked out.

All comments

bsharbo

If i'm understanding you correctly you want a new field that is just a binary "yes" or "no" based upon some logic?

if so that is very doable. You would simply add a Formula tool.

make a new field that is a "Bool" output type. Then you would put your logical if condition in your workflow.....

So for example if your logic was "if customer was sent email and customer made purchase then yes else no"

Then in your formula tool in the "expression" box you would put.

If {Field 1 customer sent email}=1 and {Field 2 customer made purchase}=1 then 1 else 0 endif.

This will create the new binary field in your workflow. No need to get excel involved at all...

Let me know if I am not understanding you fully.

akaur

Ok. will try this. will it create a field also? This means I do not need to use 'Generate Rows' tool then.

akaur

So, I have come against something not so fun.

If you see the word document that I attached, there is the Left join that has all the people who didn't purchase, the middle 'Join' has everything that joined from my two original files and then the R is all the people who didn't join either so basically were not part of the 'Join' or purchased but weren't sent the email.

I just want to add 'yes' and 'no' to these separately.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703