Magic ETL

Magic ETL

Set Data Type by Row

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

  • 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

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In