Match two tables depending of column and values

[ThibKm]

Morning,

I'm facing an issue that is too hard for my qlik skills.

You'll find below a draw of what i'm looking for.

The most important things is to match red part infos, for "fruits" that cannot always be identified with same name or codification.

Yes, this issue is due to messy data, i'm trying to make an app that would do matching job for us.

Sorry for complexity, i hope there is a way

[ThibKm]

Indeed you are right it shouldn't be a problem since i would get excepted results.

But as i want to check those 4 Tables separately, i need temporary to exclude those synthetic keys.

I can't make it works with inner join, Qlik is keeping synthetic keys with Table 2 fields

EDIT : since innerjoin data doesn't have a table name, Qlik is taking the source file as a prefix and making Synthetic keys since field got same names in the 4 tables. Any workarround ?

[Marijn]

Manually rename the fieldnames to something else temporarily. After having checked, you can continue with the script without a qualify.