Mapping

[New-here1]

Hi, 

I need some help with mapping please. Example data is below:

Name	Number
Texas	1
New York	2
Florida	3
Seattle	4
LA	5

So Texas = 1, New York = 2, Florida = 3

How can I map this in the back end please?

Thank you

[Vegar]

Take a look at mapping load combined with applymap.

Example

Map_region:

mapping load Number, Name

From MappingSource;

Data:

Load Dim1, Dim2, Applymap('Map_region', RegionID, 'Missing') as Region

From SourceData;

[PrashantSangle]

what are you trying??

If you load that table as it is then also it will map to data as per your requirement.

Not sure what are you looking for

[New-here1]

Hiya,

so the name column is already in my script but I need to now map those names to the numbers so

texas = 1, new york =2, ect.. 

I was hoping someone might be able to show me how to do this 

[Vegar]

What about using match() ?

Match(YourField, 'Texas','New York','Florida')

[PrashantSangle]

Best Possible & easiest solution is create mapping table or inline table or load data from excel where you can define value of Name And associate that table with you existing table

for example

mapping_table:

Load * Inline [

Name, Number

Texas, 1

New York, 2

Forida, 3

];

your_existing table:

Load Name, ...

...

From TableName;

Regards,

Prashant Sangle