When to load data after binary load?

[NewToQlik]

Hi all, 

I saw a difference in data when I load certain tables before binary load and after binary load. Can anyone give examples as to when I should load tables before, and when I should load after binary load? I know an example where applymap() should be done after binary load. Are there any other scenarios?

Thank you so much!

[timpoismans]

Not 100% sure about joined tables. 

I don't work with binary loads all too often. I rather load and transform my tables, store them in QVD and then load from QVD. Mapping loads don't form a problem that way either.

Best bet is to try it out and see what's going on in your data model.

That's how I often work at least 

[marcus_sommer]

Please elaborate in more detail what you are doing and which data are different to your expecting including your script, the tableviewer and examples/screenshots from your raw- and transformed-data and which one are in which way wrong.

To check/validate the data (-quality) it's quite often important to know exactly how many records are included which records are problematic in any way. For this it's useful to include recno() and rowno() within all related tables.

- Marcus