Column appears correctly on Prepare preview, but it's blank in the output

Mateus
Mateus Registered Posts: 1 ✭

I have a column of integer values that were rounded in another prepare, previous to the one I'm having issues with.

For some reason, no matter what I try, these numbers are never carried out to the output dataset, although, in the Prepare preview of the dataset, the steps are executed correctly and it displays exactly the result I expected, and the output dataset preview also has these columns correctly filled.

I tried creating another column using multiple techniques: I tried using an "If Then Else" step, I tried using val("column_name"), tried round(toNumber(val("column_name"))), tried concat(round(toNumber(val("column_name")))," "), tried toString(val("column_name")), no matter what I tried, the NUMBERS never are carried to the output dataset, although, as I mentioned, in the previews, the output dataset is correct.
I do think this might have to do with formatting and what not, but as I mentioned, I tried different workarounds and none of them worked…
I'm attaching the log. The problematic columns are "Custom Field (Week Number)" and the "formula_results".

Dataiku version used: 14.3.3

Answers

  • apichery
    apichery Dataiker, Alpha Tester, Registered, Product Ideas Manager, Moderator Posts: 66 Dataiker

    Hi Matteus,

    Please create a support ticket (https://support.dataiku.com) so that we can help you efficiently.

    Best,
    Arnaud PICHERY - VP Engineering @ Dataiku

Setup Info
    Tags
      Help me…