Data Transformations: Union Operations and Pivots in Clay Lists

·

Hi guys, I have a question about doing data transformations. Do clay lists support doing union operations on several sheets with the same column headers to create one big list? What about doing pivots or creating new rows from comma seperated values in a cell?

3 comments

· Sorted by Oldest

Jack C.
·
·
Sadly not, best way around this is, in a common table import a unique identifier, then using that look up from your "Dim" tables. Then you have all the info from your tables and can pick and choose the headers you want.
Jack C.
·
·
If you have CSV items you can break them out into separate columns with a function and then right those to a new table as rows. But its painfully manual and limited by your columns capacity
👍1
Alex N.
·
·
Ah word, I have an idea for a workaround, but thanks!
1

Loading comments

Jack C.
·
·
Sadly not, best way around this is, in a common table import a unique identifier, then using that look up from your "Dim" tables. Then you have all the info from your tables and can pick and choose the headers you want.
Jack C.
·
·
If you have CSV items you can break them out into separate columns with a function and then right those to a new table as rows. But its painfully manual and limited by your columns capacity
👍1
Alex N.
·
·
Ah word, I have an idea for a workaround, but thanks!
1