CONCATENATE Alteryx and if statement and Automation Email

[julianhoetzel]

Hey guys, 

I need from the following table: 

Number	Letter	Type
1	A	Letter
2	B	Mail

the following output

Number	Letter	Type	ID (combo of Number and Letter)	Letter existent (Yes, then show "Letter")
1	A	Letter	1A	Letter
2	B	Mail	2B

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 solution]

@julianhoetzel 

ID:

ToString(Number) + Letter

Letter Existent

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

Cheers,

Mark

[atcodedog05 · Accepted solution]

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 🙂

[julianhoetzel]

Cheers 🙂

and how do I send this report automatically to my colleagues?

[atcodedog05 · Accepted solution]

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 🙂

[julianhoetzel]

Thanks again! 🙂

One last question:
How do I show new entries when comparing two tables and highlight the new entries:

Table 1:

ID	Amount	Name
1	10	Josh
2	30	Kyle

Table 2: 

ID	Amount	Name
1	10	Josh
2	30	Kyle
2	10	Kyle

Output should be:

ID	Amount	Name
2	10	Kyle

Cheers

Julian

[atcodedog05 · Accepted solution]

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 🙂