LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
Back to discussions
Expand all | Collapse all

Two header rows, problem to convert into data

  • 1.  Two header rows, problem to convert into data

    Employee
    Posted 08-24-2016 09:56

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: dcoll

    Hello everybody.

    I am trying to do the following:


    I got data I add with an Excel node with a format like:

    Date Jan-15 Feb-15 Mar-15
    Country Wave1 Wave2 Wave3
    Spain 20 40 120
    Italy 40 70 80

    The output should be:

    Country Wave Value Date
    Spain 1 20 Jan-15
    Spain 2 40 Feb-15
    Spain 3 120 Mar-15
    Italy 1 40 Jan-15
    Italy 2 70 Feb-15
    Italy 3 80 Mar-15


    I am trying to do it with pivot node, but I can't finish it right, due to I must avoid hardcoding inside the graph (can't write 'Q3', 'Jan', etc... all has to be autonomous, in case new records are added to the source file).


    I got the solution, but it took around 10 nodes, using metadata nodes. If possible, I would like to reduce the number of nodes used, and I was wondering whether this issue could be solved easily with 2 or 3 nodes.

    Is it possible?

    Thanks in advance for your help.
    Kind regards