on 06-22-2020 12:42 PM - edited on 12-12-2023 03:10 PM by LeandraN
Table Of Contents:
There are two ways post a message:
From the home page:
From discussion boards:
For more information How to Post, Get Answers Fast
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.
Click Reply to respond to a particular post.
The Reply Message screen is similar to the Post Message screen, with these differences:
Your reply is added to the existing thread. It won't create a new thread.
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:
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:
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.
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.
thanks
Whoop, I have just learned about templates thanks to this, I'm off to find it and design some :)
And the Max is now 25 Macros you can set up. Fantastic. :D
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.
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.
Please suggest.
Regards
Kirti
Please how do I find my user id?
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!
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.
Sat, Sun & 9/2/2024 US holiday should be excluded in the calculation.
Thank you so much!
LouLex
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