Forum Discussion
Unable to slice this table by name:
I have a table that shows how many hours each worker worked on each day. Dates in the first column. Name of worker at top of the following columns with the hours they worked below their name. W...
- In the query editor, select all name columns and go to transform tab, and then select unpivot selected columns. This will give you a table with three columns: date, attribute and bake, where attribute column contains the name and the value column contains the number of hours worked for that person on that date.
Now your sliver should work properly 🙂
Please mark this as the solution if this answered your question. Kudos are welcome:)
In the query editor, select all name columns and go to transform tab, and then select unpivot selected columns. This will give you a table with three columns: date, attribute and bake, where attribute column contains the name and the value column contains the number of hours worked for that person on that date.
Now your sliver should work properly 🙂
Please mark this as the solution if this answered your question. Kudos are welcome:)
Now your sliver should work properly 🙂
Please mark this as the solution if this answered your question. Kudos are welcome:)
This solution worked. Can't believe I forgot that. Thank you very much for your help.