why integer number being transferred into decimal number after importing

Options
Lance808
Lance808 Member, ALL USERS Posts: 5 New Contributor

Hello All

 

I have faced an issue that some integer numbers being transferred into decimal numbers after importing.

The situation is I imported some code from a saved view of a module from A Model to the code cells of the list of B Model.
For example, the code 179546 in a saved view of a module from A Model will be 179546.0 in the code cells of the list of B Model.
I have already set the format of the module of A Model in TEXT, not number, so I think this is not related to the data format in A model. And the code cells of the list of B Model cannot set format, so I dont know which part transfers the format of data.

Hope kindly you can help me to slove this isuue, thank you all

 

Comments

  • Lance808
    Lance808 Member, ALL USERS Posts: 5 New Contributor

    @KirillKuznetsov 
    Sorry, I have said something wrong, I checked my model, I use composite hierarchy, not nested hierarchy, and i dont seen the error you write below.
    But thank you for your kindness help, I still want to find the reason because I am afraid it will happend agian

  • Lance808
    Lance808 Member, ALL USERS Posts: 5 New Contributor

    Dear Kirill Kuznetsov

    Thank you for your answer.

     Yes, I am trying to import code from a saved view module of A Model to a list of B Model(please let me call it "100 list" becasue I will use it in later).(import between two Model)

    Then the data source I have selected the TEXT format, so I think the format is not the reason.

     

    then I found "invaild parent" error in the child list of "100 list" when I import data to the child list of "100 list", and I check the bottom of the list then I do not find the expected codes.

    Regards,Lance

     

  • Lance808
    Lance808 Member, ALL USERS Posts: 5 New Contributor

    Dear @KirillKuznetsov 
    The code line items in the source have correctly concatenation without decimals.(using TEXT)
    The concatenation logic is if the data is before 2000years , then I will concatenation the code like 12375_2000.

    And I deleted all and input again and import them to the list of B Model again, I do NOT find the code become decimal number, but I have to find the reason why some code become decimal number because my job need..

     

    And the list of B Model which accrued this problem has a nested hierarchy

     

     

  • Lance808
    Lance808 Member, ALL USERS Posts: 5 New Contributor

    @KirillKuznetsov 

    please let me show you my data source(the property of list which applied by the module of A list), they all be TEXT format

     

    and the format of code line item in moducle  is also TEXT 

     

    So I don't think I imported from numbered line item to a code (=text)


    Regards, Lance