Duplicates on multiple Excel Loads

[#1]

Hi all,

I have a problem with the Load of script with Excel:

I have multiple Excel books in a folder that i Load with:

FROM

  [$(QvDocumentBaseName)\DS\ORDENES*.xlsx]

To catch all Excels that start with ORDENES.

It works but, the problem is:

    EXCEL 1                  EXCEL2

PK1 | Value1              PK2 | Value3

PK2 | Value2              PK3 | Value3

PK3 | Value3              PK4 | Value4

The table i obtain is (i use Distinct on load):

              PK1 | Value1

              PK2 | Value2

              PK2 | Value3

              PK3 | Value3

              PK4 | Value4

I try with temporal table with aggregation and resident load after but it don't work.

There any way to avoid this duplicates? The duplicated value that i want to obtain (PK2) is indifferent, i need only conserve one of those registers.

Thanks in advance!

Regards,

Ivan.

[#2]

Done! it's ok.

Thanks !

[sunny_talwar]

Are all the files getting loaded? or is it skipping one of the files? Logfile would be a good place to analyze this information

[Anonymous]

Hi Ivan,

When you are loading your data, you can use exists. But, if you have values that have to be accumulated or maximized, you will load all your data, and then, accumulate or calulate the max value on new table.

Regards!