copy "date" type cube into a "text" type cube

andreaLin....
andreaLin.... Active Partner
Board Developer Name Dropper First Comment
in Platform

Hi All,

I’m looking for the correct formula to use in this dataflow:

  • Cube D is a "date" type cube.
  • Cube E is a "text" type cube.

Don't worry for The selection
I’m unable to find the correct formula in the IF Statement to paste the value into the text cube (TEXT(D),"DD/MM/YYYY"). As a result, the output of the dataflow is simply "0".

CUBE D CUBE E (I WANT) CUBE E RESULT

15/01/2025 15/01/2025 0

image.png

Any suggestion?
thanks

Tagged:

Accepted Answer

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary
    Answer ✓

    Hi @andreaLin.... ,

    I'm sorry, but there is no way to copy that by dataflow, I just checked.

    The date cube's value is represented as number when written to a numeric block (as EXCEL would be doing)—but unfortunately, there's no date() function in a dataflow.

    You will need an export/import of the data to manipulate it in a datareader's ETL.

    Best,
    Helmut

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary

    Hi @andreaLin.... ,

    you've said not to worry about the selections, so I'd assume since cube e is dimensioned by "day" and cube d is not, that the day has been selected and you extend on "day"—correct?

    Next, I'd try to set up a dataview that does the same calculation as algorithm—what do you get there?

    Best,
    Helmut

  • andreaLin....
    andreaLin.... Active Partner
    Board Developer Name Dropper First Comment
    https://community.board.com/discussion/comment/19562#Comment_19562

    yes correct, i already extended
    can you simplified the the calculation as algorithm and then i will adapt to my specifif case?
    i think is possible to obtain this kind of visualization that i want

    thanks

Categories