Skip to content

Instantly share code, notes, and snippets.

@zgrge

zgrge/gist:69872410d079161cbb3385272158bf58

Created April 8, 2016 16:57
Show Gist options
  • Save zgrge/69872410d079161cbb3385272158bf58 to your computer and use it in GitHub Desktop.
Save zgrge/69872410d079161cbb3385272158bf58 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
| NUMBER | TAGS | DATES CREATED |
| 1334 | tag1;tag2;tag3;tag4 | 2015-04-08; 2016-03-09 |
| 3455 | tag3;tag5 | 2016-03-09; 2015-04-08 |
| 33455 | tag5;tag8;tag1 | 2011-11-22; 2013-11-06; 2013-11-06; 2015-03-10 |
| 2334 | tag0 | 2011-11-22; 2013-11-06; 2013-11-06; 2013-11-06; 2013-11-06; 2013-11-06 |
| 33748 | tag4;tag1 | 2014-09-03 |
| NUBER | TAG1 | TAG2 | TAG3 | TAG4 | TAG5 | DATE1 | DATE2 | DATE3 | DATE4 | |
| 1334 | X | X | X | X | | 2015-04-08 | 2016-03-09 | | | |
| 3455 | | | X | | X | 2015-04-08 | 2016-03-09 | | | |
| 33455 | | | | | X | | | 2011-11-22 | 2013-11-06 | ... |
@zgrge
Copy link
Author

zgrge commented Apr 8, 2016

How to convert top table to bottom table?
Is the bottom table optimal for searching NUMBER value by date and/or tags? Or shall I restructure it?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment