Skip to main content
Solved

FDM - Direct Relations in Transformations

S
Seasoned

Hi Team,

 

I am trying to populate FDM data model using Transformation.

I am using direct relationship in my model. Let say EntityRelationship View has two fields to and From which referes to Entity view.

 

These fields are coming as Struct<String,String> as destination type intransformation.

I was trying to add Space:externalId in this field. However it is giving Incompatible type error.

Can you please help.

Thanks,

Snehal.

Best answer by Vu Hai Nguyen

Hi,

There’s a bug that we need to fix when validating data for direct relation property, can you try to run the transformation in both way to see? The node_reference should work.

View original
    Did this topic help you find an answer to your question?

    4 replies

    V
    Practitioner
    Forum|alt.badge.img

    Hi,
    Normally you can use this UDF node_reference for this.
    In your case

    node_reference(‘sj-test-data-model’, cast(TO_ITEM_ID as STRING) as fromentity

    If that doesn’t work you can try
     

    named_struct("spaceExternalId", "sj-test-data-model", "externalId", cast(TO_ITEM_ID as STRING)) as fromentity

     

    S
    Seasoned

    Hi @Vu Hai Nguyen ,

    Thank you for your reply.

    I tried both way, it is still showing as invalid type

    Thanks,

    Snehal.

    V
    Practitioner
    Forum|alt.badge.img
    • Vu Hai Nguyen
    • Practitioner
    • 21 replies
    • Answer
    • March 20, 2023

    Hi,

    There’s a bug that we need to fix when validating data for direct relation property, can you try to run the transformation in both way to see? The node_reference should work.

    S
    Seasoned

    Hi @Vu Hai Nguyen 

     

    I tried running transformation directly ignoring the warning and was able to run it successfully with both ways.

    Thanks a lot for help!

     

    Thanks,

    Snehal.

    V
    1 person likes this
    • V
      Vu Hai Nguyen

    Reply


    Terms & ConditionsCookie Settings

    Cookie Policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie Settings