Set Data Type by Row

user05850
user05850
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