Customer specific expressions

[jstensig]

Hi,

Is it possible to have customer specific expressions and how do I make it work?

I have the following table - with a specific expression for each CustomerID

Best regards

[Anonymous]

Is it practical for you to add an extra field in the load-script that you set with something like

if( match(ItemGrp, '10', '13', '15'), '1',

     if( match(ItemGrp, '40', '50', '51', '2',

        if( match( ItemNo, '100', '101', '102', '3'

            if( match( ItemNo, '220', '221', '4', 'unknown') ) ) )  as CustomerID

[MarcoWedel]

maybe helpful:

The Magic of Variables

regards

Marco

[jstensig]

Hi Herbert

Over time the number of specific expressions will grow and I´m looking for an automated solution rather than manually maintaining the load script.

Anyway, your idea brought up some other ideas I will try out 🙂

Have a nice day

[jstensig]

Hi Marco

Thank you for posting - very interesting subject !

Kind regards