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

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