Add columns between text
- Suscribirse a un feed RSS
- Marcar tema como nuevo
- Marcar tema como leído
- Flotar este Tema para el usuario actual
- Favorito
- Suscribir
- Silenciar
- Página de impresión sencilla
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
I wanted to add a columns between quotations in my json file in recordID 3
for example this should be replaced
"staticContent": " "
with
"staticContent": " column2 "
¡Resuelto! Ir a solución.
- Etiquetas:
- Dynamic Processing
- Preparation
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
I don't have Alteyx in my System Can you please share jpeg image for better reference
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
If field1 equals Blank(StaticContent) then New Column Name
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
Blank function is not working
Can you suggest me the proper formula?
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
may be its isBlank as, i don't have access to Alteryx so i don't know how to structured formula properly
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
like this?
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
Hi @tjamal1
Try this Regex based solution
REGEX_Replace([Field_1], '(.*?: ")( )(")', '$1 '+[Daysoftheweek]+ ' $3')
The search strings breaks down to this
(.*?: ") 1st capture group. All characters up to the ': "'
( ) 2nd capture group. The single space between the 2 double quotes
(") 3rd capture group. The final double quote
The replace string is
'$1 '+ the 1st capture group from above
[Daysoftheweek]+ the contents of the column [DaysoftheWeek]. change this to whatever you need
' $3' The 3rd capture group
The end result of this is that the 2nd capture group(the single space between the double quotes) is replaced by the contents of the [DaysoftheWeek] column.
The results for your dataset are
Dan