Try your hand at analyzing royal sentiment in Dataiku DSS! Learn more

Coloring / highlighting rows and exporting in Excel

Level 2
Coloring / highlighting rows and exporting in Excel
Hello,

It would be nice to have a plugin that allows to color rows based on a formula or criteria, and to have the color / highlight kept when exporting to an Excel file.

Best regards.
0 Kudos
2 Replies
Dataiker
Dataiker

Hello Tomtom,

 

Not sure if such plugin could be easily implemented but what you can do right now is the following : 

- In a prepare recipe, add a column to flag the color you want that row to have based on a formula step or a flag step (lets say that is your 6th column and it contains 'RED')

- Export to Excel

- In excel, use conditionnal formatting based of a formula to color the whole line based on your 6th column (Col F), see here for how to build such formula in excel : https://trumpexcel.com/highlight-rows-based-on-cell-value/

You formula should look like '=$F1="RED"'

 

 

Hope it helps !

Guillaume Ferdmann - CSM Dataiku
Level 2

Having, in DSS (prepare recipe for instance), a right-click "Color <color> lines containing '<pattern>' in this column" would be great.
There's already a "highlight" feature but it doesn't cover Excel exports.

0 Kudos
Labels (3)