Vitaliy Dataiker

  • 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…
    ·
  • 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…
    ·
  • 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…
    ·
  • 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 …
    ·
  • 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'…
    ·