change values in the field

[arulsettu]

Hi

i have a field like this

instead of S and I i have to display store and individual ho can i do that? thanks.....

[senpradip007]

Use , instead of ;

[MK_QSL]

Load below table first..

Mapping_Table:

Load * Inline

[

     Type, Name

     I, Indivisual

     S, Store

];

Now in the table where your CustomerType is there... use below

ApplyMap('Mapping_Table',CustomerType) as TypeName,

Hope this help..

[arulsettu]

Hi Manish

applymap throws script error... thanks..

[MK_QSL]

Can you upload your file or sample data?

[senpradip007]

can you upload your script or sample file?

[MK_QSL]

Sorry, Mapping Word was missing in Mapping Load Table...

[MK_QSL]

it should be

Mapping_Table:

Mapping Load * Inline

[

     Type, Name

     I, Individual

     S, Store

];

Now in the table where your CustomerType is there... use below

ApplyMap('Mapping_Table',CustomerType) as TypeName,

[arulsettu]

hi i attached the file

[MK_QSL]

Try enclosed file now...

[MK_QSL · Accepted solution]

You can use like below also...No need for Mapping Load

ODBC CONNECT32 TO [MS Access Database;DBQ=E:\sample database\AdventureWorks.accdb];

Load      CustomerID,

            IF(CustomerType = 'S', 'Store',

               IF(CustomerType = 'I', Individual)) as CustomerTypeFull;

SQL SELECT CustomerID,

    CustomerType

FROM `Sales_Customer`;