Concatenate load reduces number of rows in table

[derekjones]

Hi All

I have a curious issue. I'm doing a concatenate load of different facts into one table, however on the Script Excecution dialog box where it gets to add 'CustXRef' to the table the actual number of rows goes down from 2,586,681 to 2,431,000.

Is this actually possible, I can't see how concatenating another table would reduice the overall number of rows in the table it's being added to?

Is this just a bug in the execution dialog box or do I need to investigate further?

My thanks in advance for any assistance.

Derek

[sebdupont]

A simpler solution for your example would be to add a hardcoded field to each load, saying what the source is, then you can easily do counts in the front end. Ex.

     'StockLC' as [Source Data],

ok I understood, with a few seconds of reflection