Grouping/ Bucketing Columns Together

[Asuod_]

Hello,

I have a wide table and I'm looking group certain columns together into three groups (Location, Personnel And Skills). For example, by selecting Location it will filter the table to only Location columns (Zip code, Address, City).

Columns: Zip Code, Address, City - Location

Columns: Job, Gender - Personnel

Columns: Sales Experience, Merchandising, Management - Skills

Any help on how to do this is appreciated. Thank you!

[Qrishna]

do you also have a fieldname called location, Personnel and Skills?

you could insert this piece in each respective group fields:

if(getselectedcount(Location)>=1, 1, 0) in the conditional show for all the three location fields. similarly do for others

[Asuod_]

I do not have a fieldname called Location, Personnel and Skills. Those are the groups im looking to create,  can you elaborate on the if(getselectedcount(Location)>=1, 1, 0) not sure how this would filter out everything besides the location fields. 

[Qrishna]

provide some sample data and your expected output view. it would be much easier that way as the solution would be self explanatory.

[Kushal_Chawda]

@Asuod_  Create a Group column using inline table in script. If not you can even create this values using variable input object.

LOAD * inline [
Group
Location
Personnel
Skills ];

I am assuming you have table object with all the dimensions. You can put below expression for each dimension belongs to that group in "Show column if" option for that dimension. For eg., for dimensions Zip Code, Address, City you can put below expression

=Wildmatch(GetFieldSelections(Group),'*Location*')

If you are using variables to create Group values, you can use below expression

Wildmatch('$(vGroup)','*Location*')
Where vGroup is variable name

Similarly, you can use below expression for each dimension belongs to that group

=Wildmatch(GetFieldSelections(Group),'*Personnel*')

=Wildmatch(GetFieldSelections(Group),'*Skills*')