Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Bad column type after expanding from merged query

Hello,    I have a small problem :  When I expand a merged query, I have some specific values wich are automatically converted to date, like "24/7" converted to "24/7/2022" 24/7 is text and dosen...
Need Help
  • Manoj_Nair's avatar
    Manoj_Nair
    3 years ago

    Anonymous 

    I simulated your problem in the following data set

     

    I also got the same result as you mentioned. This happens when Transformation steps automatically detect data type. To disable automatic detection of data types, disable the option as shown below from the File Menu--> Options & Settings --> Options. You have to start fresh after making this change.  

     

    Alternatively, you can delete the "Change Type" step as shown below

     

     

Manoj_Nair's avatar
Manoj_Nair
Icon for Solution Supplier rankSolution Supplier
3 years ago

Anonymous 

I simulated your problem in the following data set

 

I also got the same result as you mentioned. This happens when Transformation steps automatically detect data type. To disable automatic detection of data types, disable the option as shown below from the File Menu--> Options & Settings --> Options. You have to start fresh after making this change.  

 

Alternatively, you can delete the "Change Type" step as shown below

 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

IT helps a lot, Thnak you, 

 

Pierre