CONCATENATE Alteryx and if statement and Automation Email

Question

Hey guys,

I need from the following table:

NumberLetterType  1ALetter  2BMail

the following output

NumberLetterTypeID (combo of Number and Letter)Letter existent (Yes, then show "Letter")1ALetter1ALetter2BMail2B

So i need for "ID" a similar CONCATENATE formula like in Excel and an IF formula that says If [Type] shows "Letter" then show "Letter" in a new column. Does this make sense?

I also want to automatically send the output to my colleagues as an email in a suitable format. Could you also advise how this works? 🙂

Thank you in advance.

Cheers
Julian

MarqueeCrew · Accepted Answer

@julianhoetzel

ID:

ToString(Number) + Letter

Letter Existent

IIF([Type]="Letter",[Type],'')

Cheers,

Mark

atcodedog05 · Accepted Answer

Hi @julianhoetzel

First 2 requirements are fairly easy refer below.

1. Turn number to string & concat 2 fields

2. Use IIF statement to output the column.

Can you tell us more about your mail requirement.

Hope this helps 🙂

atcodedog05 · Accepted Answer

Hi @julianhoetzel

You need to get email tool configuration details. This would usually be mail server details.

Here is a video which might help you. You can skip first 4 mins. https://www.youtube.com/watch?v=_OgEvg8w4vo

Tool mastery blog : https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Email/ta-p/32129

Documentation page : https://help.alteryx.com/current/designer/email-tool

Hope this helps 🙂

atcodedog05 · Accepted Answer

Hi @julianhoetzel

Here is how you can do it.

I am using join tool and setting all columns as keys. With this common rows comes out from J anchor, all left un-join (not joined) comes out from L anchor and all right un-join (not joined) comes out from R anchor. Where unjoined data is the new data. I am tapping into R anchor to get the new data.

Hope this helps 🙂