Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a requirement wherein I need to map one region value to multiple region values. For instance, the value present in the data source is 'Global', and this needs to be mapped across multiple regions specifically, 'Americas', 'Asia-Pacific', 'Canada', 'Europe', 'Hong Kong', 'LATAM' and 'MENAT'. Attaching a screenshot of what the end result should look like. It should display a count for each of the regions mentioned above.
Could you please help with the same.
Regards,
Erwin Palani
Could you post a small sample of your source data in tabular format against this expected output?
Hi Joshua ,
You could link your main table using Region as the key
Load * Inline [
%Region , Sub-Region
Global , Americas
Global , Asia-Pacific
Global , Canada
Global , Europe
Global, Hong Kong
Global , LATAM
Global , MENAT
];
Please provide with sample data for more clarity.
Best Regards,
Vikraant
Hi, thank you for the response. Please find attached the sample data.
Hi, thank you for your response. Please find attached the sample data.
Is your real data source an excel and that too wrapped celled, like in attached sample?
Yes
Try like:
LOAD [Ticket Number],
Services,
Location,
SubField(Region, chr(10)) as Region
FROM <>;
Hi Tresesco, sorry for the misunderstanding. The location field is present in the data source extracted and it needs to be mapped to the region field. The ' Region ' field is the output expected by using the location field.
Not sure I understand. Try using applymap().