Forum Discussion
Transpose and pivot columns?
Hi all, I have a table with the dates "above" the actual table. Like the image below I want to have the dates in a column next to the columns customer id, name, last name and age. I have...
Hi Anonymous ,
If the two dates ALWAYS appear in the first two rows of the table, then you can use the following as new custom column calculations:
// First date = previousStepName[Column3]{0} // Second date = previousStepName[Column3]{1}Pete
Hi Anonymous ,
If the two dates ALWAYS appear in the first two rows of the table, then you can use the following as new custom column calculations:
// First date
= previousStepName[Column3]{0}
// Second date
= previousStepName[Column3]{1}
Pete
Hi Pete,
It gives an error as below:
We cannot convert the value #date(2018, 1, 22) to type List.
Could you help me with this?
Apologies. I forgot to add the reference to the name of your previous query step.
I've updated my original response to include this.
Pete
Thank you very much, that did the trick!