Data Profiling tool

[Kanderson]

Has anyone worked with the data profiling tool that is located on the laboratory tab? It produces a field called histogram in the follow format:

0:39134

3.51176470588235:32

7.02352941176471:30

10.5352941176471:15

14.0470588235294:19

17.5588235294118:11

21.0705882352941:4

24.5823529411765:4

28.0941176470588:4

31.6058823529412:2

35.1176470588235:2

38.6294117647059:1

42.1411764705882:0

45.6529411764706:1

49.1647058823529:2

52.6764705882353:0

56.1882352941177:1

Has anyone ever charted this data with Alteryx or tableau? Any advice or tips would be appreciated?

Thank you 

[HenrietteH · Accepted solution]

Hi Kanderson,

In order to use the data for charting in Alteryx or Tableau, I would first parse it into two columns "Value" and "Count" and then use those for charting.

To do that, you first have to create individual rows for each of the values (since they are all in one field right now) and then parse them into two columns.

Both steps can be done using the text to columns tool. For the first step, you would create rows using newline (\n) as the delimiter. For the second step, you would create to columns using colon ( : ) as the delimiter.

Then, use a select tool to change the names and data types of the columns as you need them for charting.

Also see the workflow I attached.

Hope that helps!