Query in Tagging

[#1]

Hello all,

Could you please help me to sort the following problem which I face in Qlikview?

I have the following table in my qlikview application.

Region 1 has one account ABC and * indicates all the sub-accounts available in the database (say 100)

Region 2 has one account DEF and there are 2 sub-accounts B1 & B2 (out of the available say 50 sub-accounts, I take only B1 & B2 sub-accts).

Now I have to do tagging in such a way that, Region 1 picks all sub-accounts and region 2 picks only 2 sub-accts out of the available sub- accts.

Region	Account	Sub-Account
1	ABC	*
2	DEF	B1
		B2

Could anyone please help me on this?

Thanks in advance,

Vidhya

[#2]

It'd look something like this:

TABLE_ALL_SUBS:

LOAD Region, Account

Resident Origin

Where Sub-Account = '*';

Outer Join (TABLE_ALL_SUBS)

LOAD Distinct Sub-Account

Resident Origin;

Concatenate(TABLE_ALL_SUBS)

LOAD Region, Account, Sub-Account

Resident Origin

Where Sub-Account <> '*';

Rename TABLE_ALL_SUBS to Table_final.