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,

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)

      • NorMar's avatar
        NorMar
        Frequent Visitor
        2 years ago

        SUCCESS !!!   beautifull- Thanks