Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi everyone,
I'm try to use the table functions to say turn the table itself automatically, but i have a problem with this function that doesn't work,
thank you
hi
Try
CROSSTABLE (Indicatore, MyPos3)
LOAD
'Placeholder' as Placeholder,
Periodo,
Passaggi,
Passeggeri,
Destinazioni
FROM
LIB://ok/Transporti.csv (...);
DROP FIELD Placeholder;
it is not very understandable,
thank you for the request
What is it that you want to create? Can you maybe show an image?
Jordy
Climber
hi, i trust to clearly to explain
transform the table above in non manual way in the table below
the idea is here:
Hi Billy,
I don't know the exact statement, but you can also do this with the Data Manager: https://www.youtube.com/watch?v=D_03gU8GvK8
When you did this, go back to the script (check the 'locked' part) and get the script for unpivoting.
Jordy
Climber
Try
CROSSTABLE (Indicatore, MyPos3)
LOAD
'Placeholder' as Placeholder,
Periodo,
Passaggi,
Passeggeri,
Destinazioni
FROM
LIB://ok/Transporti.csv (...);
DROP FIELD Placeholder;
thank you, this is good and clean, but i have another question:
is it possible to match the period? Adding a column for each record?