Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

JSON file and embedded fields

Hi,  I have a field in a JSON file that includes a lot of information about my customer. The structure is as following : [{"Customer name": David, "lname":Orely, "ID": null, , "CUSTOMFIELD": [{"CU...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi,

    I solved a problem in this way:

    I created a copy of my data source in power BI, then filtered one of my sources based on contact_field_7 and filtered the copy of my source based on contact_fileld_3 and join them based on unique identifier. 

    It worked fine for me:)

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi,

 

I want to filter contact_field_7='Cluster Co-LEad' and contact_field_3='male.

contact_field_7 and  contact_field_3 keep different information about one person(in this casse person's role and gender'). But they are fetched as  different values of field'custom_field_id'. How can I apply this filter(contact_field_7='Cluster Co-Lead' and contact_field_3='male.)?

 

Regards,

Tooba

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi,

I solved a problem in this way:

I created a copy of my data source in power BI, then filtered one of my sources based on contact_field_7 and filtered the copy of my source based on contact_fileld_3 and join them based on unique identifier. 

It worked fine for me:)