Grouping

[#1]

Good Day,

I have a list of Products such as FBP, TCP, TRI, TRO ect.

Please advise how I can group this 2 by 2 and name it

eg. FBP + TCP = Passports

       TRI + TRO = Travel

       RFG = Person

I would then like to use these names in my list box to select what I am looking for. So instead of having 18 different products, i will now have a list of 9 using only the grouping names.

Thank you.

[stigchel]

You can do this best in load script e.g. using a mapping load, something like

MyMap:

Mapping load [From, To

FCB, Passports

TCP, Passports

TRI, Travel

....

];

Load

....

Product

Applymap('MyMap',Product) as MyGroup

....

From Source

[stigchel]

See also

Data Cleansing

[johngouws]

Hi Yolanda,

You can do it either on the Load side or if you are using SQL, on the SQL Select side.

Do you have a sample to post?

Regards - John

[#5]

Thank you so much!

Even though I used what says “Don’t use” It works and that’s the result I was looking for ☺

[stigchel]

You're welcome Yolanda

If any of this has answered your question, could you please mark the relevant answer as correct (and/or helpfull)?

Marking answers correct will close the thread, help others finding correct answers for similar problems and let other contributing members know this requires no more attention.

Thanks, Piet Hein

[#7]

Hi Piet,

Where do I mark it?

[stigchel]

There should be a correct button in each post, which you can click to mark the answer correct. Helpful answers are set using the actions drop down beneath each post and click helpful