Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Formatting the dynamic columns

Pravallika20
8 - Asteroid

Hi all,

 

I am trying to format the columns which will be added newly. I should change the color of the number to red if it is negative or else it should be black. Can anyone please help me with this. Thanks in advance!!!

7 REPLIES 7
CarliE
Alteryx Alumni (Retired)

Hi @Pravallika20 

 

In the report table tool you can apply formatting on "Unknown Fields" so once the new columns come in, they will have this formatting applied to it.

 

Please let me know if you have any questions! Mark this solution as solved if this helped so other users can benefit.

 

Thanks!

Carli
atcodedog05
22 - Nova
22 - Nova

Hi @Pravallika20 

 

As @CarliE you can need to configure column rule on an unkown column refer the snapshot.

 

atcodedog05_0-1630602105829.png

 

Hope this helps : )

 

CarliE
Alteryx Alumni (Retired)

@Pravallika20,

 

If you get any issues with that, you can use the formula option and apply it to the _CurrentField_ field. 

 

CarliE_0-1630603409904.png

 

Carli
Pravallika20
8 - Asteroid

Hi @atcodedog05 

I tried this but I am getting error at the table tool and my flow is getting Stopped. I am unable to get the output

Pravallika20
8 - Asteroid

Hi @CarliE 

Can you please share the workflow so that It would be helpful

CarliE
Alteryx Alumni (Retired)

Hi @Pravallika20 

 

Attached is the file! Please let me know if you have any questions!

 

If you found this helpful, please mark as a solution.

 

Best,

Carli
atcodedog05
22 - Nova
22 - Nova

Amazingly done @CarliE 😀👍

 

Strange I was getting datatype issue when I tried, but this one is working 🙂👍

Labels