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
Icon for Community Champion rankCommunity 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)