Roman_K Member

Also, what would be the safest way for me to remove the duplicate data for the date 2/25? Would the following process I found on ChatGPT work?

Excellent Grant, I defined it as a STRING instead of a DATETIME and the values are now coming in identically, but those two date fields are now coming into Domo as text fields. Unfortunately, in my cards, I need those two date fields to be functional (calendar format). Is there a solve that I could implement that doesn't…

Thank you Grant, I am trying your suggestion now.

From my workbench query I am bringing in data that contains two fields that are naturally date/time (OrderDate and TransactionDate), and I just want to bring in those values as they are naturally (8/26/2024 9:00:49 AM…..bring in as exactly 8/26/2024 9:00:49 AM), without a "Shift Data Timezone Transform". Is there a setting…

I was able to successfully remove the leading zero using the following: CASE WHEN INSTR(fd.PO_NO, ''0'') = 1 THEN SUBSTR(fd.PO_NO, 2) ELSE fd.PO_NO END AS PO_No,

Thank you, exactly what I was asking

I have tried your suggestion in the following 2 ways, I am getting a workbench error: Value cannot be null (parameter name: replacement): Add a Search/Replace Transform in one step: Click on the "Add Transform" button and select "Search/Replace Transform" from the menu. In the Search/Replace Transform Editor, select the…

Thank you for your suggestion, I tried it, but am getting the message that it's too much data (over 100k rows). Is there a way to accommodate larger data sets in a Pivot Table card?

Is it not working properly perhaps because an ItemNumber can have multiple SKUs?

Hi. Thank you for providing direction, it is much appreciated. Here are the details of my pivot tile, but the column I'm creating (Demand_Qty by Week_End_Date) is still empty for all rows.

Yes, I have confirmed that the problem is not input dataset that is locked. If forced to delete this job & re-create it in the workbench, would my downstream workflows that already use this data still work as long as I re-create the job identically?

Is there any other way to accomplish separating TransactionDate (date/time format) into 2 pieces in the workbench other than converting it to a string, I do need to be able to do date operations?