MAP Complex datatype | Community
Skip to main content
V
VijayLa
Level 2
May 30, 2024
Solved

MAP Complex datatype

  • May 30, 2024
  • 1 reply
  • 1429 views

Hello Experts,

 

I want to add value to field which is defined as MAP datatype (Complex type)

 

 

 

I am giving the following as calculated field as shown in screenshot below.

ID_SPECIFIC_SMS_FLAG - 'n'

 

but the field IdSpecific is not updated with 'n'; it shows as null . Please assist me.

 

 

Thanks,

Viji.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Ankit_Chaudhary

    Hi @ankit_chaudhary 

    The schema is pre defined. I don't think we can change the datatype of the Schema .

    Its known limitation.

     

    can you think of a work around in this situation?

     

    Also, can you give me some examples of values stored for MAP datatype.

     

    Thanks,

    Vijay.


    yes you are correct you can't change the type of standard fields only, however the schema is not predefined you can create your own new fields as per the requirement check this tutorial on how to add new fields in a schema, i would recommend creating a new field which is best suited for your requirement(an enum would be better if you just want to save "y" or "n") then use data prep functions to alter your data accordingly for the new field 

     

    Now again the map data type is used to store key value pairs in a field a common example of map type field is Identity map refer to this document for more details on map type fields.

    1 reply

    Ankit_Chaudhary
    Community Advisor
    Ankit_ChaudharyCommunity Advisor
    Community Advisor
    June 1, 2024

    Hi @vijayla

    as per the description of to_map function it will take comma separated strings and create key value pairs for example if you provide to_map("first","value1","second","value2") you'll get first:value1 and second:value2

    it seems to be some syntax error hence you are getting the null results.

    could you provide some more context on the variables you are using in your map function.

      V
      VijayLaAuthor
      Level 2
      June 3, 2024

      Hi @ankit_chaudhary 

       

      Thanks for the details. My Objective is to populate the IDSpecific field with a value of either 'y' or 'n'. My source is snowflake View. When I attempt to map directly from snowflake view field to Id Specific field, it throwed the below error

      The source field with the leaf schema type STRING cannot be mapped to the destination field of type MAP. Please use the correct source schema type that corresponds to the destination field type and try again.

       

      Please suggest a best method to populate the value in Id Specific field.

       

      Thanks,

      Vijay

        Ankit_Chaudhary
        Community Advisor
        Ankit_ChaudharyCommunity Advisor
        Community Advisor
        June 4, 2024

        Hi @vijayla 

        I guess If you are trying to put string values "y" or "n" in the idSpecific field you don't have to make a it map type field as map is a special type field used to store key value pairs for strings you can use logical functions during data prep using iif function  

         

        Hope this will help let me know if I am missing something

          Terms & ConditionsAccessibility statement

          Loading footer...