Handling Calculated Fields and Value Extraction in Visuals

Question & Answer
,
1

I am creating a calculated field with three elements: node_id, item_id, and date (String, String, Date data types).

After creating this calculated field, I get values in the format: Value 1 | Value 2 | Date1.

Now, I want to split these values and use only Value 1 for another calculation. So, I created another calculated field and used the following formula. However, when I try to use it in visuals, I get a database-generated error with no detailed explanation.
Calculated Field 1 (cnd):

concat(
{node_id},
’ | ',
{item_id},
’ | ',
formatDate(truncDate(“DD”, {alert_date}), ‘yyyy-MM-dd’)
)

Calculated Field 2:

split(toString(cnd), ’ | ', 0)

2

Hi @Ronny1

Are you using Direct Query dataset by any chance? There is a note related to this function that it does not work on Direct Query for SQL Server.

Why don’t you directly use the node_id directly?

Regards,
Giri

3

Hi Giridhar,

This is a Direct DataSet Query.

To answer your question about why I am not using node_id directly—actually, I am trying to pass one of the node_id values from a calculated field to the URL as a query parameter. When I pass the node_id attribute directly in the query parameter, it is not getting calculated, which is why I raised another question today.

Is there any chance that the action I am trying to perform is possible or any workaround possible?

4

Hi @Ronny1,
It’s been awhile since we last heard from you on this thread; are you still working on this case or were you able to find a work around in the interim?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you

5

Hi @Ronny1,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!