I am just trying to taste and dragged same excel file twice and trying data blending. It is sample superstore. Dragged category from source 1 and subcategory from source 2 in a worksheet. when dragging subcategory into filter, "null" is appearing into the picture where as there is no null values.
Faced the same issue in some real time project as well. I'm attaching the snap of the issue and the twbx file for the reference and will be thank full if get any solution for the issue.
** the issue is happening for both the cases live and extract.
Thanks and Regards
Kishanu Guha
Hey Soham, Thanks for sharing your thoughts but for my case there are no extra records in my left table. To be more clear, I have considered the same data set for testing, then also the same "null" issue is appearing. If you can see the attached twbx file you can address the issue particularly.
would like to request you to open the attached .twbx file and let me know your observations. It will be very helpful for me.
Thanks again Soham for coming up.
Regards
Kishanu Guha
