Forum Discussion

vckbx's avatar
vckbx
Icon for Helper I rankHelper I
4 years ago

Left Merge returning null for all records in Dataflow, NOT in Desktop

I've got a left merge that is returning null for all records in a dataflow. I expect some nulls, but also expect a lot of matches.   When I copy the dataflow directly into Desktop, the left merge r...
Data Protection
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi vckbx ,

 

I think it caused by the large dataset in your table, so it displays all null value at the first time. If you sort by id not the RiderId or scroll down the slider, it may show not only blank values.

 

According to this:

Please filter out RiderId=blank to see if there are other valid values

 

 

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • vckbx's avatar
    vckbx
    Icon for Helper I rankHelper I
    4 years ago

    It is returning null for all values. When I connect to the dataflow, all values are null.