Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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
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
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