Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Community Resources

Get up-and-running on the Community and with Alteryx in record time.

Posting Messages

TrevorS
Alteryx Alumni (Retired)
Created

 

Table Of Contents:

 

How do I post on the Community?

 

There are two ways post a message:

From the home page:

  1. Select Ask a Question
  2. Select which board you would like to post your message.
  3. Fill in the Subject and Message feilds. If necessary, attach your workflow with sample data.

From discussion boards:

  1. Click the New Message link.
  2. In the Subject field, enter your message title.
    Tip: Make your subject clear and concise, as it's the only part of the message that shows up on the message feed.
  3. In the Body field, type your message. Be sure to include all necessary details, especially for technical topics. Please DO NOT include proprietary data or information on the Alteryx Community. Use sample data for posting.
  4. Format and spell check your message, as needed.
  5. Click Submit Post.

For more information How to Post, Get Answers Fast

 

How do I edit my post?

 

Once you post to the community, you can make edits to your post for 24 hours. Once that 24 hour time period has elapsed, you will need to request any further edits to be made by Notifying the Community Team.

 

How do I reply to a message?

 

Click Reply to respond to a particular post.
The Reply Message screen is similar to the Post Message screen, with these differences:

  • When you reply to a post, the subject line is filled in automatically. You can change it if you want.
  • You can paste the message to which you are replying into the body of your reply by clicking the quotes (“) in the taskbar.

Your reply is added to the existing thread. It won't create a new thread.

 

Can I create "canned" or "boilerplate" responses?

 

Yes. You can use macros to create a "canned" or " boilerplate" response (also known as a pre-made response) that you can paste into any message. You can create up to 9 macros.
To set up a macro for boilerplate text:

  1. Sign in to the community.
  2. Go to My Settings > Macros.
  3. Enter a short but memorable name in the Macro Title field.
  4. In the Macro box, enter your boilerplate text.
  5. Click Save.

Tip: To add text at the bottom of your posts, you can include that text as part of your signature instead of using a macro.
To add your boilerplate text to a post:

  1. Go to a post.
  2. In the comment area, place your cursor where you want to add the boilerplate text.
  3. Open the Macros menu and select the macro you want to add.

 

 

Finding Spam

 

If you happen to find a piece of content that seems to be spam. Select the ellipses (...) on the right hand side of the post. You can then choose “Mark as Spam” and our team of Moderators will be alerted. We would appreciate your help in keeping our Community as clean as possible.

 

 

Notifying the Community Team

 

If for any reason you need assistance with a post that you have written and posted you can use the “Notify Moderator” Option. Select the ellipses (...) on the right hand side of the post. You can then choose “Notify Moderator” and our team of Moderators will be alerted and will assist you as soon as possible. If you are having account issues or seeing issues with the site, please email community@alteryx.com and a support ticket will be created for you.

Comments
Anasitani
6 - Meteoroid

thanks

Samantha_Jayne
Alteryx
Alteryx

Whoop, I have just learned about templates thanks to this, I'm off to find it and design some :)

Samantha_Jayne
Alteryx
Alteryx

And the Max is now 25 Macros you can set up. Fantastic. :D

eliaskurian
6 - Meteoroid

Team, 
Sorry if am asking in the wrong thread. 

How do I tag someone in the comment section? Typint '@' followed by the username is not working for me. 

Learneralive
5 - Atom

Hello Everyone,

 

I have to summarize two Header in one Column, However, its taking as Header & header2. How do i bring same header for both. it needs to be same coz I heed it for Join in further workflow.

 
I am unable to attach the Pic. 
 

 

 

Please suggest.

Regards

Kirti

OliviaNartey
5 - Atom

Please how do I find my user id?

yogavasu
5 - Atom

To combine two headers into one column in Alteryx, you can use the "Concatenate" function in the Formula tool. Here's a step-by-step process:

1. Select the two columns with headers you want to combine.
2. Drag the Formula tool onto the canvas and connect it to the selected columns.
3. In the Formula tool, enter the following expression:

[Header1] + " " + [Header2]

This will concatenate the values in Header1 and Header2 with a space in between.

1. Name the new column (e.g., "Combined Header").
2. Connect the output to a Select tool to rename the column, if needed.

Alternatively, you can use the "Union" function in the Formula tool:

Union([Header1], [Header2])

This will combine the values without a space.

For joining purposes, ensure the combined header column has the same data type and format as the column you're joining with.

If you're still having issues, feel free to describe your workflow, and I'll provide more tailored guidance!

PaweeArce
5 - Atom

Hello,

Hope everyone is doing great. Appreciate if someone can help me in determining the formula or workflow to identify the 10th Business Day FROM and BEFORE a certain date. I have attached the sample data for reference.

 
Sample Data.png
 

Sat, Sun & 9/2/2024 US holiday should be excluded in the calculation.

 

Thank you so much!

LouLex

 

Lsambias
6 - Meteoroid

Buenos días, estoy trabajando con la conexión de Oracle (quick connect) y tengo un Qry que me funciona en SQL, pero cuando lo pego en Alteryx no me lo toma me genera error. puede ser por alguna particularidad de códigos de Alteryx.

SELECT
TTC012_IDDTEXT || '-' || TO_NUMBER(TTC086_ITEM) || '-' || TO_NUMBER(TTC086_SUBITEM) AS "Dir-Item-Subitem",
TTC001_FACTURA_IMP,
TTC012_VIAJE_IMP,
TTC012_CONOCIMIENTO_IMP,
PIEZA_PARA_RAF(PIEZA_SUFIJO_VALOR(TTC086_SUFIJOS_VALOR), TTC086_PIEZA_CRUCE) AS pieza,
TTC015_PROVEEDOR_IMP,
DECODE(TTC086_SUBITEM, '0000', TTC085_CANT_DECLARADA, TTC086_CANT_DECLARADA) AS TTC086_CANT_DECLARADA,
TTC086_IND_NACIONAL,
TTC086_CANT_NACIONALIZADA,
TTC012_FECHA_OFICIALIZACION,
TTC012_FECHA_LIBERACION,
Fecha_dua(TTC012_DESPACHO_IMP, TTC012_DIG_CONTROL_DESPACHO, TTC012_ANIO_DESPACHO, TTC012_ADUANA, TTC012_SUBREGIMEN, 115) AS TTC012_CARGA_LIBERACION,
TTC012_FECHA_FEEDBACK
FROM
DBAORATC.V1TC012_DESPACHO_FECHA_LIB,
DBAORATC.TTTC086_DUA_ITEMS_SUBIT,
DBAORATC.TTTC085_DUA_ITEMS,
DBAORATC.TTTC001_FACTURA_IMP,
TTTC015_EMB_IMP_PIEZA_PROD
WHERE
TTC086_DESPACHO_PERMISO = TTC012_DESPACHO_IMP
AND TTC086_DIG_CONTROL = TTC012_DIG_CONTROL_DESPACHO
AND TTC086_ANIO = TTC012_ANIO_DESPACHO
AND TTC086_ADUANA = TTC012_ADUANA
AND TTC086_SUBREGIMEN = TTC012_SUBREGIMEN
AND TTC086_DESPACHO_PERMISO = TTC085_DESPACHO_PERMISO
AND TTC086_DIG_CONTROL = TTC085_DIG_CONTROL
AND TTC086_ANIO = TTC085_ANIO
AND TTC086_ADUANA = TTC085_ADUANA
AND TTC086_SUBREGIMEN = TTC085_SUBREGIMEN
AND TTC086_ITEM = TTC085_ITEM
AND TTC012_VIAJE_IMP = TTC001_VIAJE_IMP
AND TTC012_CONOCIMIENTO_IMP = TTC001_CONOCIMIENTO_IMP
AND TTC001_FACTURA_IMP = TTC015_FACTURA_IMP(+)
AND TTC001_PROVEEDOR_IMP = TTC015_PROVEEDOR_IMP(+)
AND PIEZA_PARA_RAF(PIEZA_SUFIJO_VALOR(TTC086_SUFIJOS_VALOR), TTC086_PIEZA_CRUCE) = TTC015_PIEZA_BPS_PROD(+)
AND TTC012_IDDTEXT LIKE '%DIR%'
-- Filtro Por Fecha Oficializacion
AND TTC012_FECHA_OFICIALIZACION >= TO_DATE('01/03/2024', 'DD/MM/YYYY')
AND TTC012_FECHA_OFICIALIZACION <= TO_DATE('03/07/2024', 'DD/MM/YYYY');

Me podrían indicar si hay algo para modificar