Conditional Formatting/Sums

Question

Hi there,

This is what my data currently looks like

Vendor A     50-Empty     2

Vendor A     75-Inbound   3

Vendor A     60-Outbound 2

Vendor A      40-Dock Door 4

This is what I want it to look like

Vendor A     Empty  2

Vendor A     Utilized 9

Any help is greatly appreciated.

Thank you!

atcodedog05 · Answer

Hi @nwatzlaf

Here is how you can do it.

1. Split the string into columns using Regex tool parse method.

2. Data cleanse tool to remove leading & trailing spaces

3. Formula to categorize empty & utilized

4. Summarize groupby vendor, category & sum of value

5. Displaying as single string

Hope this helps 🙂

condition format.yxmd

nwatzlaf · Answer

So any category other than empty is summed together.

atcodedog05 · Answer

Hi @nwatzlaf

Can you provide the logic on how you are arriving at the output.