Regarding Add column in flowgraph

[former_member558580]

Hi All,

I have added field in aggregation node in flowgraph created based on table (SDI).

But i am not able to do any calculation for this field like we are able to do in calculated column in HANA CV.

Could you please help.

Thanks

Devesh Varshney

[jeffrey_kresse]

With some quick testing, I found that an added column does not appear in the 'Aggregations' tab until it is mapped from an input column and the flowgraph is saved.

1. Create column
2. Map column from input node
3. Save flowgraph
4. Close Aggregation node, and re-open it
5. Now you can do a Sum, Count, Min/Max, etc on the added column based on its mapping. The default aggregation action is Group By.

Best regards,
Jeff K

[former_member558580]

HI Jeff,

Can i perform if else logic for added new column in flowgraph, just like we can do in CV in hana

[jeffrey_kresse]

Without more detail I can't be sure what you want to accomplish with this if-else logic, but I think if you aggregate and then pass the output to a Case node you can accomplish a kind of if-else step in the flowgraph. I'd recommend checking out the descriptions and examples for each node in the SDI Modeling Guide.

Best,

Jeff

[former_member558580]

Hi Jeff,

I am trying in Case statement which is showing sql error :

CASE WHEN "CaseTransform2_Input"."Version" = 1 THEN 10 ELSE 100 END

Could you please tell me error here .

Thanks

Devesh Varshney

[former_member558580]

Hi Jeff,

Now my case statement is not giving any error , but it is not working .

Below is the statement

CASE WHEN "CaseTransform2_Input"."Version" = '1' THEN ("CaseTransform2_Input"."test_sdi" = '10') ELSE ("CaseTransform2_Input"."test_sdi" = '100') END

Can u please tell.

Thanks

Devesh Varshney

[jeffrey_kresse]

Case transform works more like a filter that divides your data into different paths, if case transform is doing anything it will have multiple outputs. For logic like you have shown in latest reply, you can implement it in the filter node mapping editor.

[former_member558580]

Hi Jeff,

How should i write same logic in filter node. I am getting error there.

Thanks

Devesh Varshney