Group items in a dimension table

[#1]

Hi

I have a dimension table in my script and I want to group the data items so if i have:

Expense AE

Expense AA

Expense AC

These should appear in Expense A

[#2]

yeah or LocalPointofdelivery

[its_anandrjs]

the values AFAO, AFTUO are not available in the fields.

[#4]

typo ATFAO and ATFUO

[its_anandrjs · Accepted solution]

Ok in your load statement put a code like this

If(Match(Category,'ATFAO','ATFUO'),'Out',Category) as NewCat

By this your 'ATFAO','ATFUO' are goes to Out category as what ever you want and other is same category. In the same above you can add for others category also what ever you decide i done here for category field.

Hope this helps

[#6]

thats worked.  Thank you for your help

[its_anandrjs]

You are welcome....

Thanks & Regards