mstorne Member

• Activity
• Posts3
• Comments15

• Creating New DataFlow from Zips2Fips DataSet and ODBC DataSet

  mstorne

  January 2018
  I have USA map card that I want to drill down to counties. I got Zips2Fips DataSet from DomoSolutions that I have to join to my DataSet. I tried to do that through Magic ETL joining these two DataSet…
  1

• %change Year over Year

  mstorne

  July 2018
  Hi all, I am trying to make a card where I will have bars for total premium by year, and one line which will show % change betwen years (current to previous, previous to two years ago etc.). Do you h…
  1

• Re: Creating New DataFlow from Zips2Fips DataSet and ODBC DataSet

  mstorne

  January 2018
  I am matching ZIP_STRING field since I can't use ZIP, it says they are different data types. Here is a screenshot. Thank you.
  1

• Re: Creating New DataFlow from Zips2Fips DataSet and ODBC DataSet

  mstorne

  January 2018
  I already tried to convert string from my ODBC to whole number but I keep receiving an error "Failed to convert data 94563 to type integer for column AcctZipCode". Thank you for your help.
  1

• Re: Creating New DataFlow from Zips2Fips DataSet and ODBC DataSet

  mstorne

  January 2018
  Here is my outpu. Thank you.
  1

Next