Applying tags to field names

[JacobJones]

Hi All,

I have a spreadsheet from a form. It asks questions like:

1. Did you drink two litres of water today?   <---Good

2 . Did you eat junk food?    <----Bad

3. Did you have a serving of vegetables?   <---Good

I want to be able distinguish between questions about 'good' things and questions about 'bad' things. So in the above example I need to flag 1 and 3 as good questions and 2 as bad questions. Then I want to count the amounts of yes in each category. I'm familiar with the idea of loading a table and then adding flags based on the values in a field but not how to flag the field itself. 

I want to apply tags to YN Vegetables, YN Junk, YN Water. So YN Vegetables is about 'good things' and YN Junk is about bad things. Eventually there would be other tags like YN Vegetables is about food and YN Water is about drinks. Once that is all done I want to actually count the values. 

Any help is greatly appreciated. I know it is a bit strange conceptually, but I'm sure you can see how powerful this would be. 

[Rodj · Accepted solution]

Hi @JacobJones ,

When you say tags I think you mean you want to add fields with a value, or at least that's how I'd do it. I think first though I'd pivot the data so that instead of fields "YN Vegtables", "YN Junk" etc they would become a column of questions. You can do this in the data manager or add your own crosstable statement in your load:

    TempTable:

    Crosstable(Question, Answer, 1)

    Load Date, "YN Vegetables", "YN Water" etc...

You could then add as many new fields as you like, effectively giving you a way of tagging each question/answer pair and meeting your requirement to be able to filter by good/bad or whatever other categories you wish to add. e.g.,

    NewTable2:

    Load

    if("YN Vegetables" = 'Y', 'Good', 'Bad') as [Good or Bad],

   *

   resident TempTable;

   Dropt table TempTable; // no longer needed

Is that the sort of thing you are after? Hope it helps.

Cheers,

Rod