Data360 Analyze

 View Only

  • 1.  Pivot Names to Data Node Help

    Posted 08-14-2024 10:33

    I'm inputting an excel spreadsheet with a lot of serialized column names such as DateInstalled1, DateInstalled2, DateInstalled3 as well as TotalBat1, TotalBat2, TotalBat3 and so on. I need to push DateInstalled2 and 3 column data to new records under DateInstalled1. I also need to pass a non serialized column (parentid) to each new record as well. Below is a example:

    FROM:

    parentid | DateInstalled1 | DateInstalled2 | DateInstalled3 | TotalBat1 | TotalBat2 | TotalBat3

    TO:

    parentid | DateInstalled1 | TotalBat1

    parentid   DateInstalled2   TotalBat2

    parentid   DateInstalled3   TotalBat3

    It's my understanding I should use "Pivot - Names to Data" node, however, I'm unsure on how to setup PivotFields, DataOutputFields, NameOutputFields, TypeConversion, and OutputNullCells properties correctly to facilitate the format I'm looking for. Thank you. 



    ------------------------------
    Shawn Pelletier
    Knowledge Community Shared Account
    ------------------------------


  • 2.  RE: Pivot Names to Data Node Help

    Posted 09-05-2024 10:28

    Hey, not sure if you got that sorted out. Maybe post a sample line with an example of what you'd like.



    ------------------------------
    Peter Sykes
    Data Governance & Architecture
    Vontobel Holding AG
    Zurich
    ------------------------------

    Original Message