Forum Discussion

NorMar's avatar
NorMar
Frequent Visitor
2 years ago
Solved

Splitting one column in multiple tables based on text in rows containing specified text

I have a simple CSV file, which is updated weekly, adding new data to the file   The file contains agregated data with both time periods; Daily, weekly and monthly downloads. However all the data i...
Need Help
  • dufoq3's avatar
    dufoq3
    2 years ago

    Import your dataset csv to this format and name whole your dataset query as "WholeDataset"

     

    Then create blank query and paste there whole my code. Edit only 1st step to this:

    Source = WholeDataset,

dufoq3's avatar
dufoq3
Community Champion
2 years ago

You are doing something wrong. Have you changed first step Source to your dataset? Can you upload your dataset to google drive / one drive and share with us?

NorMar's avatar
NorMar
Frequent Visitor
2 years ago

It appears that you are referrring to a JSON object, while I have the complete data set as seperate CSV file. I tried to replace the reference to the JSON object, but that backfired  🙂      (Due to co company policy, I have limited option to any file sharing services)

  • dufoq3's avatar
    dufoq3
    Community Champion
    2 years ago

    Import your dataset csv to this format and name whole your dataset query as "WholeDataset"

     

    Then create blank query and paste there whole my code. Edit only 1st step to this:

    Source = WholeDataset,

    • NorMar's avatar
      NorMar
      Frequent Visitor
      2 years ago

      I get error message, when I try to replace the source. Can you please clearyfi, where I need to change the source reference: 

       

       

       

       

      • dufoq3's avatar
        dufoq3
        Community Champion
        2 years ago

        You have to replace whole code after Source = 

        (don't forget comma at the end of your code)