Counting text in multiple columns together

[khandelwal]

Hi,

I want to count a specific text in a column and also want to do this for multiple columns (6 columns in a single table). Need help. I am only able to do it one column at a time.

Sample Table:

[TABLE="width: 898"]
<tbody>[TR]
[TD]Month Text[/TD]
[TD] Week Ending[/TD]
[TD] Column 1[/TD]
[TD]Column 2[/TD]
[TD]Column 3[/TD]
[TD]Column 4[/TD]
[TD]Column 5[/TD]
[TD]Column 6[/TD]
[/TR]
[TR]
[TD]Dec'18[/TD]
[TD="align: right"]19-Dec[/TD]
[TD]ABC, DEF, GHIJK, LMN[/TD]
[TD]OPQ, RST, UVW[/TD]
[TD]ABC, DEF, GHIJK, LMN[/TD]
[TD]OPQ, RST, UVW[/TD]
[TD]ABC, DEF, GHIJK, LMN[/TD]
[TD]OPQ, RST, UVW[/TD]
[/TR]
[TR]
[TD]Nov'18[/TD]
[TD="align: right"]02-Nov[/TD]
[TD]ABC, DEF, GHIJK, LMN[/TD]
[TD]OPQ, RST, UVW[/TD]
[TD]ABC, DEF, GHIJK, LMN[/TD]
[TD]OPQ, RST, UVW[/TD]
[TD]ABC, DEF, GHIJK, LMN[/TD]
[TD]OPQ, RST, UVW[/TD]
[/TR]
[TR]
[TD]Oct'18[/TD]
[TD="align: right"]06-Oct[/TD]
[TD]ABC, GHIJK, LMN[/TD]
[TD]OPQ, RST, UVW[/TD]
[TD]ABC, GHIJK, LMN[/TD]
[TD]OPQ, RST, UVW[/TD]
[TD]ABC, GHIJK, LMN[/TD]
[TD]OPQ, RST, UVW[/TD]
[/TR]
[TR]
[TD]Dec'18[/TD]
[TD="align: right"]19-Dec[/TD]
[TD]ABC, DEF, GHIJK, LMN[/TD]
[TD]OPQ, RST[/TD]
[TD]ABC, DEF, GHIJK, LMN[/TD]
[TD]OPQ, RST[/TD]
[TD]ABC, DEF, GHIJK, LMN[/TD]
[TD]OPQ, RST[/TD]
[/TR]
[TR]
[TD]Nov'18[/TD]
[TD="align: right"]02-Nov[/TD]
[TD]ABC, DEF, GHIJK[/TD]
[TD]UVW[/TD]
[TD]ABC, DEF, GHIJK[/TD]
[TD]UVW[/TD]
[TD]ABC, DEF, GHIJK[/TD]
[TD]UVW[/TD]
[/TR]
[TR]
[TD]Oct'18[/TD]
[TD="align: right"]06-Oct[/TD]
[TD]ABC, DEF, LMN[/TD]
[TD]OPQ[/TD]
[TD]ABC, DEF, LMN[/TD]
[TD]OPQ[/TD]
[TD]ABC, DEF, LMN[/TD]
[TD]OPQ[/TD]
[/TR]
[TR]
[TD]Dec'18[/TD]
[TD="align: right"]19-Dec[/TD]
[TD]GHIJK[/TD]
[TD]OPQ, UVW[/TD]
[TD]GHIJK[/TD]
[TD]OPQ, UVW[/TD]
[TD]GHIJK[/TD]
[TD]OPQ, UVW[/TD]
[/TR]
[TR]
[TD]Nov'18[/TD]
[TD="align: right"]02-Nov[/TD]
[TD]DEF, GHIJK, LMN[/TD]
[TD]RST, UVW[/TD]
[TD]DEF, GHIJK, LMN[/TD]
[TD]RST, UVW[/TD]
[TD]DEF, GHIJK, LMN[/TD]
[TD]RST, UVW[/TD]
[/TR]
[TR]
[TD]Oct'18[/TD]
[TD="align: right"]06-Oct[/TD]
[TD]LMN[/TD]
[TD]UVW[/TD]
[TD]LMN[/TD]
[TD]UVW[/TD]
[TD]LMN[/TD]
[TD]UVW[/TD]
[/TR]
</tbody>[/TABLE]

I was not able to format it here.

Now I want to count e.g. "*OPQ*" in the table from column 1, parallelly I want to count "*UVW*" from column 4 grouped by either month or Week ending.

I hope I have explained my requirement.

 

[ranman256]

your table is not normalized and wouldn't be designed this way,
but you can make 6 queries, 1 for each column.
combine them in UNION query,