Filtering on one particular field but want the report to show two columns with info

[dlemoine]

I am creating a report and want to filter on two particular information which is 'OFF_GRP' and 'LINEMAN' but I have a couple of queries which are as follows:

1) The report only displays one response so I assume my filter is incorrect. ANy ideas what I have done wrong with this as I entered [Dimension COde] = "OFF_GRP" OR [Dimension Code] = "LINEMAN". I also tried changing the 'OR' to and @and' but that displayed no results for the dimension code.

2) How would I get two columns to display in the report ie a column for LINEMAN and a column for OFF_GRP rather than have one column called Dimension Code.

I attach my workflow.

[binuacs]

@dlemoine  Try the IN operator if you have multiple or condition

[Dimension COde]  IN ("OFF_GRP" ,"LINEMAN")

for the second question you need to transpose the data and do the cross tab. 

[ChrisTX · Accepted solution]

As @binuacs mentioned you can use the IN operator. 

But there is nothing wrong with this code: [Dimension COde] = "OFF_GRP" OR [Dimension Code] = "LINEMAN".  The filter tool isn't case-sensitive. Guessing something else is going on.   Can you post a sample workflow with that code, showing the unexpected results?

Chris

[dlemoine]

I did a simple workflow using that filtering and it worked so the issue is somewhere else in my workflow. 

[dlemoine · Accepted solution]

The code did not work but discovered my other one did work when I put it inot a workflow on its own so there must be an issue somewhere else within my workflow.

Apologies I am fairly new to Alteryx so I don't suppose you have any guidance note on how to use transpose?

[binuacs · Accepted solution]

@dlemoine try the tool mastery

Tool Mastery | Transpose - Alteryx Community

also you can find example and explanation for the transpose tool by clicking the tool you will see open example, which will open a sample workflow and you can learn from there. 

[ChrisTX]

Under the Transform tab, single-left-click on the Transpose tool and click Open Example.

and see the Tool Mastery index: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Index/ta-p/84593

Related posts for Transpose / Crosstab:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Transpose-Question/m-p/345557#M63103

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Transpose-or-cross-tab-help/m-p/376063...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Addresses-1-Row-to-Multiple-Rows/m-p/3...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Merge-rows-per-header/m-p/370022#M6795...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Transpose-or-CrossTab-Not-working/m-p/...