Filter Using String Data

achadaga

Hi all,

        I am trying to filter json data containing more than one fields. How should i go about it. Basic filter allows me to use one variable. And I am not parse error while using custom filter. 

Below is the example of the problem i am facing.

My json file contains both address and date along with many other columns. How do i put both the strings in the same filter tab instead of using many.

Contains([JSON_Name],"address")
Contains([JSON_Name],"date")

DylanB

It looks like these are your general steps:

• Use text-to-columns tool to separate the record ID. This seems to be the part up to the first period, so your delimiter will be a period (".").
• Re-name and re-type the fields we just made
• Since each row only has one value between 'ValueString', 'ValueInt', and 'ValueFloat', we can concatenate these together. This is going to require turning numerical values into strings since there's no way to add a string (even if it's empty) to a number.
• Use the cross-tab tool to turn 'JSON_Name' categories into our columns.
• Now, fields can be re-named and re-typed

I'm attaching a workflow that takes a little bit of your data (including the lat/long coordinates) and follows this process (with comments). Let me know if you have trouble with the other JSON_Name values. The most important part will be that you rename and retype your fields (particularly the date field) in the last step. 

In general, it is easier to get help on your problems if you send some data instead of a screen shot of it, since it's easier for someone to use a "Input Data" tool than to type a copy of your data in.

JSON_achadaga_help.yxmd