Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.....
Use , instead of ;
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..
Hi Manish
applymap throws script error... thanks..
Can you upload your file or sample data?
can you upload your script or sample file?
Sorry, Mapping Word was missing in Mapping Load Table...
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,
hi i attached the file
Try enclosed file now...
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`;