user10539 Member

Comments

  • Thanks. I receive this data every week. If I use data connector upload file, I will have to do it manually every week. I was looking for something that can automate this whole process, which I was able to do by using the unpivot function. Thanks to all of you for your quick replies!
    in Combining two header rows Comment by user10539 December 2020
  • Thanks, I was able to achieve what I was looking for by using 'Dynamic Pivot' function of the magic ETL. Thanks again for your help!
    in Combining two header rows Comment by user10539 December 2020
  • It is an emailed dataset. Since first few headers are blank in the first header row, DOMO is renaming it as C1, C2.... and reading the rest of the lines as data (please see attached)
    in Combining two header rows Comment by user10539 December 2020
Default Avatar