-
Re: Convert columns to rows
Hi, when you look at the requirement, it is a pretty simple table transformation. However, to make this transformation is complex enough. The one way to do it is to use multiple prepare recipes to cr…4 · -
Re: Access FTP location from Python Code
Hi Sagar, If I understood correctly and the requirement is to access some files in one FTP folder, archive them and move to another FTP folder, then it isn't DSS specific but more a Python exerc…2 · -
Re: Create a new Date column
Hi Alexé, It is still a bit confusing what you are trying to achieve. Let's assume you have a dataset that has a Date column in 'yyyy-MM' format and you don't have all Date values…1 · -
Re: Using Excel Sheet name
Hello, It is not clear what you mean by saying, "I need the name of the sheet as a value in DSS", please provide your use case for a better understanding of the requirement. If you want to …1 · -
Re: How to change connection for SQL Notebook
Hi, Unfortunately, this is not possible. A SQL notebook is attached to a single SQL connection of DSS, which means the SQL connection needs to be selected while creating an SQL notebook and can'…2 ·