Set Data Type by Row

user05850
user05850 Member
in Magic ETL

Hi,

 

Is it at all possible to set data types by row or specified account?

 

We are trying to build a card that shows a P&L view, which would require importing accounts that have multiple data types (i.e., $ for Gross Margin, % for Gross Margin %).

 

Thanks!

Comments

  • eric_tetik
    eric_tetik Member

    Hi there,

     

    Just to get more context, is there something stopping you from using the text datatype for the relevant columns? If you can provide a screenshot of the data that would give us a better idea of what you're dealing with (if you do decide to provide a screenshot don't forget to censor any sensitive data!)

     

    Cheers,

    Eric

Categories