Hi Everyone,

I am looking for some guidance on the following scenario using Data Prep within Tableau CRM:

Object A: Val1

Object B: Rec1 Rec2 Rec3

Expected Dataset output 

Val1Rec1

Val1Rec2

Val1Rec3

Please note there are no common keys between the 2 objects. 

We tried the following: Utilized Data Prep by creating 2 new fields with same "Field name" in Object A like Object B and use APPEND function and Map Object A and Object B to the 2 new field names. 

The output results:

Dataset output

"Null"Rec1

"Null"Rec2

"Null"Rec3

Val1"Null"

Val1"Null"

Which does not meet the Expected Dataset output

Thank you in advance

Andrew